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.