File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes using :new in oracle JDBC Query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "using :new in oracle JDBC Query" Watch "using :new in oracle JDBC Query" New topic

using :new in oracle JDBC Query

Kedar Bhawarthi

Joined: May 14, 2004
Posts: 8
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

Joined: Oct 11, 2000
Posts: 1141

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,
Kedar Bhawarthi

Joined: May 14, 2004
Posts: 8
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:
subject: using :new in oracle JDBC Query
It's not a secret anymore!