| ALTER keyword in SP [message #35985] |
Sun, 28 October 2001 23:40  |
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  |
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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
