alter table

[koma42]

Hola,
necesito crear un script que haga un alter table, tengo esto pero me da error.
sccj.sql
--------
DECLARE
V_TIPOSERV INTEGER;
BEGIN
ALTER TABLE DOCSADM.LOGJMO ADD (NUM_EXPEDIENTE INTEGER);
END;

ERROR en línea 4:
ORA-06550: line 4, column 1:
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 <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe
The symbol "lock was inserted before "ALTER" to continue.
ORA-06550: line 4, column 32:
PLS-00103: Encountered the symbol "(" when expecting one of the following:
, in
ORA-06550: line 5, column 1:
PLS-00103: Encountered the symbol "END" when expecting one of the following:
begin function package pragma procedure subtype type use
<an identifier> <a double-quoted delimited-identifier> form current cursor

[Zoe79]

Que yo sepa no puedes hacer un alter en un trigger.

[kikolice]

tal vez si lo intentas con algo asi te funcione

execute immediate('ALTER TABLE DOCSADM.LOGJMO ADD (NUM_EXPEDIENTE INTEGER');