Do you want to read environment variables set in the database server's operating system? I don't know of any officially supported way to do this in Oracle. Why do you need to do that
would your select statement run in sqlplus?
Azahrudhin Mohammad wrote:CREATE TYPE myNumType AS VARRAY(10) OF NUMBER; is the syntax for creating the env variable in oracle.
Use the CREATE TYPE statement to create the specification of an object type, a SQLJ object type, a named varying array (varray), a nested table type, or an incomplete object type.
Ashwin Sridhar wrote:The third option is interesting, but If my generic query changes, then I need to make a big change again.
I cannot imagine how the code in your last post could give Table or View Doesn't exist, since you don't try to access a table in it.