Hi All,
I'm trying to ececute below code and resulting to the error message : PLS-00382 : expression is of wrong type
Please have a look into below block of code.
DECLARE
P_POLICYNUMBERS schema.Listof policynumbers_t;
P_PRODUCTHOLDINGDETAILS SYS_REFCURSOR;
BEGIN
package.procedure(
P_POLICYNUMBERS => P_POLICYNUMBERS,
P_PRODUCTHOLDINGDETAILS=P_PRODUCTHOLDINGDETAILS
);
:P_PRODUCTHOLDINGDETAILS := P_PRODUCTHOLDINGDETAILS;
END ;
however getting below error messages :
Error report:
ORA-06550: line 8, column 3:
PLS-00306: wrong number or types of arguments in call to 'ProcedureName'
ORA-06550: line 10, column 5:
PLS-00363: expression '<expression>' cannot be used as an assignment target
ORA-06550: line 8, column 3:
PL/SQL: Statement ignored
ORA-06550: line 15, column 20:
PLS-00382: expression is of wrong type
ORA-06550: line 15, column 3:
PL/SQL: Statement ignored
- 06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
any help will be really appritiated.
Thanks
Deshmukh