File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

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.


java.sql.SQLException:ORA-06550:line1,column7:
-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: 71

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 ?

Claudiu
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: CallableStatement -JDBC