hi all,
when i try to do the following insert:
BEGIN
INSERT INTO DS_ANAGR_PM_KEYA
(KEY_ANAGR_COLL
,DS_ANAGR
,DT_COLLEGAMENTO)
VALUES
(PM_012.KEY_DS_ANAGR_COLL
,VL_ANAGR_PREC
,SYSDATE);
it give me the error:
RA-06553: PLS-103: Encountered the symbol "(" when expecting one of the following:
ORA-06553: PLS-103: Encountered the symbol "(" when expecting one of the following:
delete exists
prior
The symbol "" was substituted for "(" to continue.
ORA-06553: PLS-103: Encountered the symbol "(" when expecting one of the following:
i cannot understand why, it is just an insert and also the anonymus block is inside a pl/sql function that is correctely compilited.
thanks
Francesco
Italy