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 ...
![]() |
| | LinkBack | Thread Tools | Display Modes |
|
#1
| |||
| |||
| 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. |
![]() |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
| |
| ||||
| 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.




Linear Mode
