dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Error while calling a stored procedure using SQLJ - Oracle Errors

This is a discussion on Error while calling a stored procedure using SQLJ - Oracle Errors ; I am calling a stored procedure defined inside a package through a SQLJ script. The first parameter of that procedure is a IN OUT parameter which is used as a ROWID for creating a cursor. That ROWID value is the ...


Home > Database Forum > Oracle Database > Oracle Errors > Error while calling a stored procedure using SQLJ

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 02-07-2008, 07:49 AM
Database Newbie
 
Join Date: Feb 2008
Posts: 1
ananth.pksh is on a distinguished road
Default Error while calling a stored procedure using SQLJ

I am calling a stored procedure defined inside a package through a SQLJ script. The first parameter of that procedure is a IN OUT parameter which is used as a ROWID for creating a cursor. That ROWID value is the same for every record in the table, thereby enabling us to create a cursor.

When I give a hard-coded value as a parameter, I get an error stating that the assignment is not correct as the query is expecting a variable and not a literal. Hence I removed the hard-coded value and included a dymanic value in the SQLJ call.

String strVal = "A";
#sql{CALL ASSIGNMENTS_PKG.INSERT_ROW :{strVal},'SALARY_CODE_GROUP','BU',3,105,sysdate,1 ,sysdate,1,1)};

Here "ASSIGNMENTS_PKG" is a package name and INSERT_ROW is the procedure.

When the SQLJ program is run, I get an error stating:

"PLS-00201: identifier 'A' must be declared"

I read the error message, but I am not able to understand where I need to give the GRANT permission to.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Unable to tune stored procedure by switching indexes and code chan Database Administrator sqlserver-programming 4 02-03-2008 01:44 AM
Getting Error 1934 when calling stored procedure Database Administrator sqlserver-server 2 01-28-2008 06:07 PM
Re: [NOVICE] Reason(s) not to use a stored procedure Database Administrator postgresql 0 01-22-2008 02:41 PM
Error executing extended stored procedure: Invalid Parameter Database Administrator sqlserver-server 1 12-11-2007 05:01 AM
Shall I use Transaction in this stored procedure? Database Administrator sqlserver-programming 2 12-06-2007 02:27 PM


All times are GMT -4. The time now is 04:24 PM.