0
I already tried with the sql%rowcount but when it’s a Rigger it just doesn’t work.. how can I return the number of lines manipulated in a DML instruction from a Trigger?
0No answers
Browser other questions tagged oracle pl-sql
You are not signed in. Login or sign up in order to post.
It would only make sense for STATEMENT and AFTER , under what conditions you need it?
– Motta
I am trying to create a Trigger that prevents an update or delete without Where, for this I need to know the number of lines that are being manipulated and if this number of lines is equal to the number of lines in the database (select Count(*) from table) I go up an error message.
– Harry
For this BD has backup , foreign key etc. The direct sql access to the production bd must be controlled and applications only devdm "rise" after test , test bench serves to steer this , at most have a load script if it gives slgum error. The focus would be another.
– Motta