Home » SQL & PL/SQL » SQL & PL/SQL » ALTER keyword in SP
ALTER keyword in SP [message #35985] Sun, 28 October 2001 23:40 Go to next message
Elav
Messages: 7
Registered: October 2001
Junior Member
Hi there,

I tried to disable triggers in the procedure.
Here is the query I put in my SP.

ALTER TRIGGER RAW_BASIC_INFO_TRIG DISABLE;

But while compiling the SP, i got the following error.

PLS-00103: Encountered the symbol "ALTER" when expecting one of the following:
begin declare exit for goto if loop mod null pragma raise return select update while <an identifier>
<a double-quoted delimited-identifier> <a bind variable> << close current delete fetch lock insert open rollback savepoint set sql execute commit forall
<a single-quoted SQL string>

Cann't we have a ALTER keyword in SPs?
Need your help.

Thanks in advance.

Rgds
Elav

----------------------------------------------------------------------
Re: ALTER keyword in SP [message #35988 is a reply to message #35985] Mon, 29 October 2001 06:51 Go to previous message
Phenoracle
Messages: 35
Registered: March 2001
Member
Hi,

This is not a DML operation so is not allowed in
a PL/SQL block.
But do not dispair for you can use Dynamic SQL or NDS to process this command.

Have fun

Rae



----------------------------------------------------------------------
Previous Topic: Running a BAT file from PL-SQL
Next Topic: using values of dynamic sql
Goto Forum:
  


Current Time: Sat May 28 00:12:30 CDT 2022