Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes Problem in accessing package variable through trigger Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem in accessing package variable through trigger" Watch "Problem in accessing package variable through trigger" New topic
Author

Problem in accessing package variable through trigger

Balaji Munuswamy
Ranch Hand

Joined: Apr 07, 2002
Posts: 37
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
 
Consider Paul's rocket mass heater.
 
subject: Problem in accessing package variable through trigger