Sunday, June 21, 2015

ORA-00604: error occurred at recursive SQL level 1


I was trying to call a DB procedure with complex (record/table types) parameters. When i tried to test the procedure i got the below error

ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SYNCRN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


This is a known issue as identified by oracle and a patch is already provided for DB. This issue is related to incompatible standard procedure with db version. Please refer to doc 1586704.1 for more details on this issue.

No comments: