Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

CallableStatement Error: must be declared

 
Pavan Kumar
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hari,
"pavan" does not fulfill the requirements our naming policy has set for display names. Please, change it here.
Thanks.
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oracle does not accept double quotes for quotation marks. You need to use the single quotation mark. So change all of your " with '
Mark
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Also change your name like Lasse asks.
Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic