| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| 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. |
![]() |
| Thread Tools | |
| Display Modes | |