File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

CallableStatement Error on Oracle Stored Procedure.

 
Kunjal Shah
Greenhorn
Posts: 13
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3901
16
Eclipse IDE Flex Google Web Toolkit
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic