Home » Developer & Programmer » Forms » CREATE_RECORD question
CREATE_RECORD question [message #134219] Tue, 23 August 2005 22:44 Go to next message
pinkpepper
Messages: 1
Registered: August 2005
Location: Philippines
Junior Member
Hi,

Would anyone happen to know which triggers can use the procedure CREATE_RECORD?

I created a program unit that will create a new record if the previous record satisfies some condition. Then I called the program unit in trigger WHEN-VALIDATE-RECORD, but the problem is I always get the error: FRM-40737 - Illegal restricted procedure CREATE_RECORD in WHEN-VALIDATE-RECORD trigger.

Report message to a moderator

Re: CREATE_RECORD question [message #134259 is a reply to message #134219] Wed, 24 August 2005 02:04 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Go to http://www.oracle.com/technology/documentation/forms.html. Find 'Form Builder Reference'. Download it and search for 'WHEN-VALIDATE-RECORD'.

WVI and WVR can only process SELECT statements and unrestricted built-ins. To create a record you should really use a button.

David

[Updated on: Wed, 24 August 2005 02:05]

Report message to a moderator

Previous Topic: reg export to excel from forms
Next Topic: Bad Bind Variable
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 01:41:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.