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-00363: expression cannot be used as an assignment target

user640001Dec 2 2010 — edited Dec 2 2010

Hi,

Oralce9.2

when I run the insert procedure I get the below error:

Procedure
--------------

PROCEDURE proc_one_insert(col1 IN OUT numeric,
col2 IN num,
col3 IN numeric
);

BEGIN
execute immediate proc_one_insert(2,1,111);
END;
/

Error
------

PLS-00363: expression '2' cannot be used as an assignment target

How to solve the above error ?

With Regards

Edited by: user640001 on Dec 2, 2010 3:04 AM

This post has been answered by Arun Kumar Gupta on Dec 2 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 30 2010

Added on Dec 2 2010

7 comments

29,772 views