posted 20 years ago
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.