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
I'm not sure what the problem is but you might consider some debugging practices when trying to diagnose a problem and/or ask for help. You've posted a lot of code that is probably unrelated to the problem. I'd start smaller, cutting out large chunks of code until you find the root cause of the problem. Not many people want to read through entire stored procedures looking for bugs. [ September 13, 2006: Message edited by: Scott Selikoff ]