aspose file tools*
The moose likes JDBC and the fly likes CallableStatement Error on Oracle Stored Procedure. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "CallableStatement Error on Oracle Stored Procedure." Watch "CallableStatement Error on Oracle Stored Procedure." New topic
Author

CallableStatement Error on Oracle Stored Procedure.

Kunjal Shah
Greenhorn

Joined: Aug 28, 2005
Posts: 13
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
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3716
    
    5

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 ]

My Blog: Down Home Country Coding with Scott Selikoff
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: CallableStatement Error on Oracle Stored Procedure.