Hello,
I am having problems calling a Stored Procedure from
Java. This is the relevant portion of my code...
Oracle Stored Procedure.
I get an error ORA-01403: no data found --
ORA-01403: no data found
ORA-06512: at "TEST_USER.UPDATE_CAT_COUNT", line 13
ORA-06512: at "TEST_USER.POSTS_DELETE", line 20
ORA-06512: at line 1...
The line 13 in UPDATE_CAT_COUNT is
> select parent_id into p_id from categories where id = in_catid;
I know that the error means there is now row returned by the Select Into statement... But somehow when I run the procedure on the SQL*Plus
call " + sql_prefix + "posts_delete(2)
it runs fine !!.. I would appreciate any help/tips to resolve this.
Regards