• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in accessing package variable through trigger

 
Balaji Munuswamy
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic