forms ddl insert
486740Jan 31 2006 — edited Feb 18 2009I 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;