How to execute a Db procedure with IN and OUT parameters from the sqlplus prompt?
I need your help to run the procedure from the sqlplus command line:
This is the specification of the procedure:
PROCEDURE calc_int(
P_JOB_NO IN NUMBER ,
P_TAX_TYPE_NO IN NUMBER ,
P_ASSESS_NO IN NUMBER ,
P_IRD_EMPLOYEE_NO IN NUMBER ,
P_ERROR_CODE OUT NUMBER ,
P_ERROR_MSG OUT VARCHAR2 ,
P_WHERE_CALLED IN VARCHAR2 )
This is the specification of the procedure:
PROCEDURE calc_int(
P_JOB_NO IN NUMBER ,
P_TAX_TYPE_NO IN NUMBER ,
P_ASSESS_NO IN NUMBER ,
P_IRD_EMPLOYEE_NO IN NUMBER ,
P_ERROR_CODE OUT NUMBER ,
P_ERROR_MSG OUT VARCHAR2 ,
P_WHERE_CALLED IN VARCHAR2 )
SQL> Begin SIGTASAD.TA26P.CALC_INT(0,13,1494831,6,NULL,NULL,'S'); End ;
2 /
Begin SIGTASAD.TA26P.CALC_INT(0,13,1494831,6,NULL,NULL,'S'); End ;
*
ERROR at line 1:
ORA-06550: line 1, column 46:
PLS-00363: expression ' NULL' cannot be used as an assignment target
ORA-06550: line 1, column 51:
2 /
Begin SIGTASAD.TA26P.CALC_INT(0,13,1494831,6,NULL,NULL,'S'); End ;
*
ERROR at line 1:
ORA-06550: line 1, column 46:
PLS-00363: expression ' NULL' cannot be used as an assignment target
ORA-06550: line 1, column 51:
0