This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft 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 | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem in accessing package variable through trigger
 
Similar Threads
why compile time error???
A doubt with triggers
Setting up classpath for JDBC JAR in resources.xml
Using Oracle package variables in JDBC.
set bean value with onlick event