This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes Problem in accessing package variable through trigger Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Problem in accessing package variable through trigger
 
Similar Threads
Using Oracle package variables in JDBC.
Setting up classpath for JDBC JAR in resources.xml
why compile time error???
set bean value with onlick event
A doubt with triggers