This week's book giveaway is in the Agile and Other Processes forum. We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line! See this thread for details.
Problem in accessing package variable through trigger
posted 14 years ago
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.