dynamic variable declaration
599569Mar 12 2008 — edited Mar 13 2008I need a way to reference a global package variable from a separate stored procedure. Normally, I would be able to just assign its value to a local variable within the procedure: local_variable := package_name.gobal_variable;
However, I need to dynamically build this package_name, because I have a series of these packages. i.e. package_1, package_2, etc.
In Oracle Forms, I know you can use the NAME_IN function, but I haven't been able to do this in a stored procedure. I am hoping there is some built-in function that I can use from within a stored procedure, but I haven't been able to find one.