aspose file tools*
The moose likes Oracle/OAS and the fly likes CallableStatement Error:  must be declared Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "CallableStatement Error:  must be declared" Watch "CallableStatement Error:  must be declared" New topic
Author

CallableStatement Error: must be declared

Pavan Kumar
Greenhorn

Joined: Jan 13, 2002
Posts: 8
Hi I am executing a stored procedure.It is giving following exception.

SQLException: [Oracle][ODBC][Ora]ORA-06550: line 1, column 7:
PLS-00201: identifier 'GGNVCONTACT.ADDCONTACTDETAILS1' must be declared
ORA-06512: at line 1
This is the code.

cs3 = con.prepareCall("{call GGNVCONTACT.ADDCONTACTDETAILS1(?,?,?,?,?,?,?,?,?,?,?,?,?,?) }");
cs3.setString(1,"Customer_Ref");
cs3.setInt(2,1);
cs3.setDate(3,dat);
cs3.setString(4,"");
cs3.setString(5,"");
cs3.setString(6,"");
cs3.setString(7,"213132");
cs3.setString(8,"");
cs3.setString(9,"");
cs3.setString(10,"");
cs3.setString(11,"");
cs3.setString(12,"");
cs3.setString(13,"");
cs3.setInt(14,2);
cs3.execute();

thanks and regards
Hari.


pavan kuamr
Lasse Koskela
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
Hari,
"pavan" does not fulfill the requirements our naming policy has set for display names. Please, change it here.
Thanks.


Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17260
    
    6

Oracle does not accept double quotes for quotation marks. You need to use the single quotation mark. So change all of your " with '
Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17260
    
    6

Also change your name like Lasse asks.
Mark
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: CallableStatement Error: must be declared