Skip to Main Content

Oracle Forms

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!

forms ddl insert

486740Jan 31 2006 — edited Feb 18 2009
I have gone over many forms ddl code and still cannot get this insert statement right.... I have worked on this for a day now so any help would be thankful
I have a when button pressed trigger
with this code
Declare

REMP_ID number(2);
Request_ID number(7);
Pending Varchar2(10);

begin
REquest_ID := :control.text_item126;
pending := 'P';
remp_id := :global.tracker;
/*This is so I know that my variables are working*/
:text_item136:= remp_id;
:text_item137:= pending;
:text_item138:= request_id;
:text_item139:= sysdate;


FORMs_DDL('INSERT INTO request VALUES('||remp_id||''','''||request_ID||''','''||sysdate||''','''||Null||''','''||pending||')');

/*have tried variations of single quotes to no avail*/

End;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2009
Added on Jan 31 2006
11 comments
4,677 views