File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "CallableStatement Error on Oracle Stored Procedure." Watch "CallableStatement Error on Oracle Stored Procedure." New topic

CallableStatement Error on Oracle Stored Procedure.

Kunjal Shah

Joined: Aug 28, 2005
Posts: 13

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.
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

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 ]

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: CallableStatement Error on Oracle Stored Procedure.
It's not a secret anymore!