Posted: Thu Jul 11, 2002 12:58 am Post subject: accessing ORACLE schemas
Newbie
Joined: 12 Jan 2002 Posts: 3
Hi,
In our methodology, we have different environment test using for each one a schema for the same ORACLE instance.
Actually, i have to refer a stored function using PASSTHRU command like:
select SCHEMA1.FUNCTION_FS('10') from dual;
select SCHEMA2.FUNCTION_FS('10') from dual;
Is there a way to externalise these schema names "SCHEMA1" and "SCHEMA2" (promote properties or compute node, odbc.ini file, ...) and avoid coding them directly in ESQL ?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum