Home » RDBMS Server » Server Administration » Dynamic triggers
Dynamic triggers [message #370966] Wed, 19 July 2000 09:16
Messages: 4
Registered: July 2000
Location: VA
Junior Member

I need to implement Dynamic triggers on some tables and
tried to do it on Pro*C. Before 'EXEC IMMEDIATE' the
create trigger script, I write the string(script) into
a text file. After execution , I found the trigger was
created but always invalid when I tried to use it.
Strange thing is, when I copy the same code from the
text file, and paste it to sqlplus to recreate the
trigger, it works. Anyone can help me with this?
What happens there?
Thanks a lot.
Previous Topic: v$session
Next Topic: Error from Performance Manager
Goto Forum:

Current Time: Mon May 27 23:05:16 CDT 2024