File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes CallableStatement -JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "CallableStatement -JDBC" Watch "CallableStatement -JDBC" New topic

CallableStatement -JDBC

Karthikeyan Pandian
Ranch Hand

Joined: Jun 09, 2013
Posts: 66
I am getting this error even after successful compilation. I have displayed the codes here kindly, help me out.

Oracle procudure

But when i execute the program I am getting the following error.

-00201: identifier 'PROC1' just be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

What is the error saying about.
Claudiu Chelemen
Ranch Hand

Joined: Mar 25, 2011
Posts: 74

Well, what is the name of the procedure you've just created on the database ?
Then, what's the procedure you're trying to call from the java code ?

I agree. Here's the link:
subject: CallableStatement -JDBC
It's not a secret anymore!