Ceriwis  

Go Back   Ceriwis > HOBI > Komputer & Teknologi > Programming

Programming Share, tanya jawab, saling bantu antar programmer dengan berbagai macam bahasa pemrograman.

Reply
 
Thread Tools
  #1  
Old 20th November 2011
Guesuper Guesuper is offline
Ceriwiser
 
Join Date: Nov 2011
Posts: 408
Rep Power: 15
Guesuper mempunyai hidup yang Normal
Default (ASK) syntak alter trigger di dalam procedure [ORACLE]

agan2 yang baik, saya punya pertanyaan lagi,



seperti judul diatas



bisa ngga kita masukin alter trigger(untuk disable /enable) ke dalam sebuah stored procedure?



saya uda bikin



Create or replace procedure switch_repl(

is_blokir smallint

)is

begin

if is_blokir=1 then

begin

alter trigger AGEN_AD0 disable;

alter trigger AGEN_AI0 disable;

alter trigger AGEN_AU0 disable;





cuma katanya kok ecountered symbol ALTER... saya jadi bingung..



mohon pencerahan

</div>
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Terkait
Thread Thread Starter Forum Replies Last Post
[ASK]ALTER Object Type di Oracle Darkc0der Programming 0 20th November 2011 11:26 PM
[ASK] Trigger oracle SinggahDapur Programming 0 20th November 2011 12:16 PM
Create Trigger dan Procedure MYSQL dengan Logika IF Servermaster Programming 0 20th November 2011 11:46 AM
[need] butuh tips dan trick dalam mempelajari oracle Braincode Programming 0 11th November 2011 01:56 PM
[ask]tentang trigger oracle [help] Braincode Programming 0 11th November 2011 01:18 PM

 


All times are GMT +7. The time now is 07:07 AM.