File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

using :new in oracle JDBC Query

 
Kedar Bhawarthi
Greenhorn
Posts: 8
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
I calling a Java procedure from within oracle trigger.
But in that procedure I am not being able to get access of :new variable in query fired by JDBC.
I get error as
oracle.jdbc.driver.OracleSQLException: ORA-01008: not all variables bound

Please help me to fix this.


My Trigger is written like this


...where FRAUD_SCORE_TBL_ROW_ADDED procedure maps to a java procedure 'rowAdded'


I am trying to execute a code in rowAdded as...


My understanding is, if some code, executing under trigger (may be written in java, or PL/SQL) should have access to this :new variable.
Please correct me if I amk wrong.
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Bhawarthi,
Any stored procedure (either java or PL/SQL or C) does not have access to :new or ld. You can only access these in the trigger code, not in the code of the procedure that is called by the trigger code.

Good Luck,
Avi.
 
Kedar Bhawarthi
Greenhorn
Posts: 8
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks Avi, I am convinced to this fact now and adopted a workaround (a constrained one), thanks for your reply.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic