Forums Register Login

Problem in accessing package variable through trigger

+Pie Number of slices to send: Send
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
They weren't very bright, but they were very, very big. Ad contrast:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1118 times.
Similar Threads
why compile time error???
Setting up classpath for JDBC JAR in resources.xml
A doubt with triggers
set bean value with onlick event
Using Oracle package variables in JDBC.
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 05:07:21.