Hi Folks,
I am working on a problem to modify delivery dates for all the PO lines that have same doc ID using below script-
declare
info_ varchar2(4000);
n1 varchar2(4000);
CURSOR c1 IS
SELECT COUNT(ORDER_NO) from PURCHASE_ORDER_LINE_ALL_CFV
WHERE CF$_ID_DOCUMENT = &CF$_ID_DOCUMENT
AND ORDER_NO = &ORDER_NO;
BEGIN
OPEN c1;
FETCH c1 INTO n1;
CLOSE c1;
FOR l1 IN n1 LOOP
PLANNED_DELIVERY_DATE := &PLANNED_DELIVERY_DATE;
ifsapp.purchase_order_line_api.Modify__(info_, &OBJID, &OBJVERSION, PLANNED_DELIVERY_DATE, 'DO');
COMMIT;
END LOOP;
end;
now the only problem is that I get the error saying the ORA-06550: line 9, column 241:
PLS-00456: item 'N1' is not a cursor.
I need to know why am I getting this error this should not be an issue.
I already tried using n1 as number in DECLARATION but that didnt solve the issue either.
A little guidance or help would be much appreciated.