Wait for the value to change in table and then execute next procedure

[mili3]

Hi

I need help with a procedure , which checks for a value ina tableA.col , if the value is true then executes the next procedure. How do we write a procedure to check for the value in the table and wait for next execution..

Mili

 

[feherke]

Hi

I think you want a [tt]trigger[/tt]. Something like this :

create trigger [green][i]nameofthetrigger[/i][/green]
after insert or update of [green][i]nameofthecolumn[/i][/green] on [green][i]nameofthetable[/i][/green]
for each row
when (new.[green][i]nameofthecolumn[/i][/green] is null)
call [green][i]nameoftheprocedure[/i][/green];

Feherke.

http://rootshell.be/~feherke/