| Dynamic triggers [message #370966] |
Wed, 19 July 2000 09:16 |
qzheng2005
Messages: 4
Registered: July 2000
Location: VA
|
Junior Member |
|
|
Hello,
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
