Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00382 : expression is of wrong type

DeshmukhPJun 5 2014 — edited Jun 5 2014

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

  1. 06550. 00000 -  "line %s, column %s:\n%s"

*Cause:    Usually a PL/SQL compilation error.

*Action:

any help will be really appritiated.

Thanks

Deshmukh

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2014
Added on Jun 5 2014
2 comments
888 views