Skip to Main Content
Forums

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EBS installation in linux guide

Tony007Feb 8 2020 — edited Feb 9 2021

hi where can i get document on how to install EBS In linux and where to download EBS

Comments

388131
First of all I would reconsider if you really need to create a trigger inside a procedure. Question the reason...
Then, if you really need to do create it that way, you could try dynamic sql.
Ludock
This trigger have to be on all tables.

After creation a table, i call the procedure to generate the trigger.
388131
Well, then proceed with dynamic SQL.

Or, in my opinion much better: produce a SQL script with variables for table name and trigger name.
Then run this script with the appropriate values every time you have created a table.

Cheers,
Guido

Edited by: Guido on Oct 22, 2008 10:30 AM
1 - 3

Post Details

Added on Feb 8 2020
#general-ebs-discussion
3 comments
71 views