Erreur commençant à la ligne: 3 de la commande -
BEGIN
UPDATE sdcsequence SET sequencevalue = (SELECT COUNT (s_metastasisid) FROM s_metastasis) WHERE sdcid = 'lv_metastasis' AND sequenceid ='mainkey';
IF sql%rowcount = 0 THEN INSERT INTO sdcsequence (sdcid, sequenceid, sequencevalue) VALUES ('lv_metastasis', 'mainkey', (SELECT COUNT (s_metastasisid) FROM s_metastasis));
END IF;
Rapport d'erreur -
ORA-06550: Ligne 4, colonne 7 :
PLS-00103: Symbole "end-of-file" rencontré à la place d'un des symboles suivants :
( begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<identificateur> <identificateur entre guillemets>
<variable attachée (bind variable)> << continue close
current delete fetch lock insert open rollback savepoint set
sql execute commit forall merge pipe purge
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
Partager