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!

expression is of wrong type

ömer faruk akyüzlüMar 15 2018 — edited Mar 15 2018

Hello...

ORA-06550: line 13, column 40: PLS-00382: expression is of wrong type ORA-06550: line 12, column 38: PLS-00382: expression is of wrong type

..............................................................

DECLARE

aurunid number;

begin

for aurunid in (select urunid

from

PURCHASE_ORDER_DETAILS

where

po_number=:P77_PO_NUMBER_1 )

LOOP

UPDATE  teklif_urun a

   SET PO_NUMBER = ( SELECT PO_NUMBER

                     FROM PURCHASE_ORDER_DETAILS b

                    WHERE b.urunid = a.urunid and b.poid=1 )

where a.po_number is null and a.urunid=aurunid ;

  END LOOP;

END;

This post has been answered by GregV on Mar 15 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2018
Added on Mar 15 2018
13 comments
2,542 views