Menu de navegação

[Anônimo]

DECLARE

TOT NUMBER;

BEGIN
SELECT COUNT(*) TOTAL INTO TOT
FROM TRUSTY_DB_PATCHES;

IF TOT>0 THEN
DBMS_OUTPUT.PUT_LINE (‘********** POR FAVOR DELETE TODOS REGISTROS DA TABELA TRUSTY_PLANO_ACAO_PA E RODE O SCRIPT NOVAMENTE *********’);

ELSE

ALTER TABLE TRUSTY_PLANO_ACAO_PA MODIFY DO_STATUS NOT NULL;
END IF;

END;

Olha o erro:

ORA-06550: line 16, column 9:
PLS-00103: Encountered the symbol “ALTER” when expecting one of the following:

begin case declare exit for goto if loop mod null pragma
raise return select update while with
<< close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe

[Autor]

Posts