Process → New → Source → PL/SQL Code
ORA-06550: satır 4, sütun 17: PLS-00103: "<(select count(*) from teklif_stok where PURCHASE_ORDER_DETAILS_ID=:P92_PURCHASE_ORDER_DETAILS_ID) THEN insert into teklif_Stok" sembolü ile karşılaşıldı, şunlardan biri bekleniyordu: . ( * @ % & = - + < / > şurada içinde eşittir mod kalan değil not sonra <üstel (**)> <> veya != veya ~= >= <= <> ve veya gibi gibi2 gibi4 gibic arasında || gösterge çoklu küme üye alt çoklu küme Sembol "(devam etmek için """, ""<(select count(*) from
begin
if
:P92_ALINAN_ADET'<(select count(*) from teklif_stok
where
PURCHASE_ORDER_DETAILS_ID=:P92_PURCHASE_ORDER_DETAILS_ID) THEN
insert into teklif_Stok PURCHASE_ORDER_DETAILS_ID values (:P92_PURCHASE_ORDER_DETAILS_ID) ;
;
ELSIF
:P92_ALINAN_ADET'>(select count(*) from teklif_stok
where
PURCHASE_ORDER_DETAILS_ID=:P92_PURCHASE_ORDER_DETAILS_ID) THEN
DELETE * teklif_Stok WHERE PURCHASE_ORDER_DETAILS_ID=:P92_PURCHASE_ORDER_DETAILS_ID AND URUN_ADI IS NULL
ELSIF
:P92_ALINAN_ADET'<(select count(*) from teklif_stok
where
PURCHASE_ORDER_DETAILS_ID=:P92_PURCHASE_ORDER_DETAILS_ID) THEN
insert into teklif_Stok PURCHASE_ORDER_DETAILS_ID values (:P92_PURCHASE_ORDER_DETAILS_ID) ;
;
ELSIF
:P92_ALINAN_ADET'=(select count(*) from teklif_stok
where
PURCHASE_ORDER_DETAILS_ID=:P92_PURCHASE_ORDER_DETAILS_ID) THEN
insert into teklif_Stok PURCHASE_ORDER_DETAILS_ID values (:P92_PURCHASE_ORDER_DETAILS_ID) ;
;
end if;
commit;
end;