SQL procedure call: SQL exception - code: 6550 ORA-06550
Attempting to call a procedure SQL
:
PROCEDURE Incident_inqr
(MSISDN IN VARCHAR2
, Topic IN varchar2
,Incident_id IN varchar2 default '20120401'
, RESULT OUT number
);
java JDBC string:
SQL command: begin ? := SMASTER.SERVICE.Incident_inqr ( '9308000050','6345_NN','20120401', ?); end;
error (I get it in Russian):
SQL Exception Code: 6550 ORA-06550: Line 1 Col 13: PLS-00222: Function named 'INCIDENT_INQR' does not exist in this scope ORA-06550: Line 1 Col 7: PL / SQL: Expression Ignored
in translation:
SQL exception - code: 6550 ORA-06550: line 1, column 13: PLS-00222: function called 'INCIDENT_INQR' does not exist in this scope ORA-06550: line 1, column 7: PL / SQL: expression is ignored
?
registration output :
cs.registerOutParameter(1, oracle.jdbc.driver.OracleTypes.VARCHAR);
cs.registerOutParameter(2, oracle.jdbc.driver.OracleTypes.NUMBER);
source to share
Incident_inqr
is a procedure. Therefore it has no return value, only a parameter out
.
The correct way to call it this way:
begin SMASTER.SERVICE.Incident_inqr ( '9308000050','6345_NN','20120401', ?); end;
...
cs.registerOutParameter(1, oracle.jdbc.driver.OracleTypes.NUMBER);
In addition, this procedure must be part of a package called "SERVICE" in the schema / owned by the user SMASTER
.
source to share