Hi!
I have a PL/SQL package variable. And this package has set and get functions.
I am able to set and get the variable by calling the functions using
JDBC.
This same variable will be used in the trigger on insert/update of a table.
But the trigger is not getting the value set by the set function through JDBC.
I am using same Connection through out the process.
But this process is working when
test it at SQLPlus.
Please suggest me in this regard