SQL procedure call: SQL exception - code: 6550 ORA-06550

Attempting to call a procedure SQL


PROCEDURE Incident_inqr
, 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

1 answer


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




All Articles