OraFAQ Forum: Forms » create trigger on table at runtime

Home » Developer & Programmer » Forms » create trigger on table at runtime

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create trigger on table at runtime [message #258673]

Mon, 13 August 2007 06:06

Rafeek
Messages: 159
Registered: April 2007
Location: egypt

Senior Member

hi all
i use form 6i database 10g .
how can i create trigger on table at runtime
thax
rafeek

Report message to a moderator

Re: create trigger on table at runtime [message #258712 is a reply to message #258673]

Mon, 13 August 2007 07:48

sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata

Senior Member

See the FORMS_DDL built-in function.

Cheers
Sanka

[Updated on: Mon, 13 August 2007 07:49]

Report message to a moderator

Re: create trigger on table at runtime [message #258713 is a reply to message #258673]

Mon, 13 August 2007 07:49

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you think twice about it? Why would you want to do something like that?

Think again, until you figure out you don't want to do that at all.

If you had the EXECUTE IMMEDIATE in mind, well, it isn't supported in client-side programs. You might create a script and call it through the HOST command. Or, create a stored procedure which would create a trigger (and you'd call this stored procedure from one of forms triggers).

But once again - I'm quite sure you do not want to do that.

Report message to a moderator

Re: create trigger on table at runtime [message #258946 is a reply to message #258673]

Mon, 13 August 2007 19:09

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Do you want to create it or enable it at runtime? There is a big difference in performance.

David

Report message to a moderator

Previous Topic:	reports6i
Next Topic:	Unable to enter text

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 04:30:43 CDT 2024