Hi there,

I have Stored Procedure on my unix box and i need to access the environment variable defined on the unix box in the Stored Procedure. I am calling this stored procedure using an SQL file.
Can I pass the environment name to my Stored Procedure using an SQL file?

For example:

We have an environment variable called '$e2DefaultEnv' that has the value as 'TECH'.
I have a Stored Porcedure called "createfilters" in my Oracle DB under a schema called "E2".

Can I call the stored procedure as below?

E2.createfilters('${e2DefaultEnv}'); exit;


Any pointers will be helpful

Thanks