I need a trigger that deletes one or more rows from the trigger base table, without getting ora-4091
http://www.experts-exchange.com/Database/Oracle/Q_10037792.html
Zones:
OracleDate Answered: 03/17/1998 Grade: C Views: 0
I have a question with 2 triggers like:
1. create trigger trg_1
after update of col_x on table_1 for each row
declare
...
end;
2 create trigger trg_2
after update of c...
http://www.experts-exchange.com/Database/Oracle/Q_10051164.html
Zones:
OracleDate Answered: 05/07/1998 Grade: D Views: 0
How can I launch a host command in a database trigger?
http://www.experts-exchange.com/Database/Oracle/Q_10058976.html
Zones:
OracleDate Answered: 07/14/1998 Grade: C Views: 0
We've written a JAVA program that sometimes needs to release and renew a DHCP IP-address. As this is not possible with JAVA code, we call in the program an external commando to do the IPswitch. S...
http://www.experts-exchange.com/Apple/Hardware/Apple_Network_Hardware/Q_10172277.html
I have a block in which I am doing the validation for the required fields in the pre-insert trigger. Problem is when I find that a required field is null I am throwing an alert asking the user to e...
http://www.experts-exchange.com/Database/Oracle/Q_10190153.html
Zones:
OracleDate Answered: 08/17/1999 Grade: A Views: 0
hi all,
Forms 3 use V2 style triggers. are they still supported in Oracle 8i ?
Sudhi.
http://www.experts-exchange.com/Database/Oracle/Q_10207535.html
Zones:
OracleDate Answered: 09/22/1999 Grade: B Views: 0
I have a parent table that has a one to many child relationship with many tables. I need a cascade delete trigger with correct syntax. Keep in mind I have never written a trigger before. If you c...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10229131.html
I need to know if triggers can be written in Access that are not dependant on a data form. I am using the Access database as a back end to a VB app, so I want the trigger to run during certain data...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10231783.html
Zones:
MS AccessDate Answered: 11/10/1999 Grade: B Views: 0
hi,
I have a table which has a field called USERNAME,
this is a non KEY and NULL field. I want not to duplicate
entries in this field and raise an error when an attempt is made.
For this ...
http://www.experts-exchange.com/Database/Oracle/Q_10249180.html
Zones:
OracleDate Answered: 12/23/1999 Grade: B Views: 0
I am creating an oracle database using ODBC.. everything works except the triggers.. they all produce this error:
PLS-00103: Encountered the symbol "" when expecting one of the following:
...
http://www.experts-exchange.com/Database/Oracle/Q_10259241.html
Zones:
OracleDate Answered: 01/20/2000 Grade: A Views: 25
