• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

CallableStatement Error: must be declared

 
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
author
Posts: 11962
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Also change your name like Lasse asks.
Mark
 
reply
    Bookmark Topic Watch Topic
  • New Topic