troubleshooting Question

dbms_system.get_env and using the retrieved environment variables in Oracle 10g

Avatar of mgferg
mgferg asked on
Oracle Database
4 Comments1 Solution1500 ViewsLast Modified:
Hi,

I've been experimenting with dbms_system.get_env but struggling to actually get it to do something other than show the variable to dbms_output

I'm using this to pass a integer value to a sql script which must than use this as part of a select

e.g. (just to demonstrate) select ... from ... where x > $variable

so if variable = 10, select all entries where field X is greater than 10

and one other thing (sorry know these are a newbie questions), but should this be used in a procedure or not?

(Oracle 10g)

Thanks in advance.

Mark
(newbie)
ASKER CERTIFIED SOLUTION
Devinder Singh Virdi
Lead Oracle DBA Team

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros