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
subject: Problem in accessing package variable through trigger