Skip to Main Content
Forums

Oracle Database Discussions

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!

How to Create a Trigger

869358Jun 16 2011 — edited Jun 16 2011
I am using Oracle SQL Developer Data Modeler, and am looking to create insert triggers. How do I fill out the Trigger Properties window? For instance, when a value is entered on table 1, but its not an option on table 2, I want the trigger to insert "NA". How is this done?

Thanks! Any help is appreciated!

Comments

LarryR
In the Object Browser, there is an Accelerator for Get POV Lock Status.
Lian Norliansyah
Hi Larry,
I want to use FDM script to check.
Is the Object Browser accessible using the Client interface only?
Lian Norliansyah
I tried to initialize the script as follow:

Dim objStatus As objProcessStatus

Set objStatus = API.MaintenanceMgr.fProcessStatus(zLocation,zCategory, zPeriod)

I got the following error:
"1025 - Expected end of statement"

This error is on the Dim objStatus above.
Any advise how to make it work?
LarryR
Answer
The web client is inadequate for relatively complicated Event and Custom scripts. You should use Workbench to edit those scripts. In Workbench, there is an Accelerator that defines exactly how to retrieve the POV Lock Status.
Marked as Answer by Lian Norliansyah · Sep 27 2020
Lian Norliansyah
Hi Larry,

Thanks for your help. It works!
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 14 2011
Added on Jun 16 2011
#data-modeler, #database, #general-database-discussions, #insert, #sql-developer, #trigger
1 comment
207 views