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?
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?
Any pointers will be helpful