| using forms_ddl to insert [message #83636] |
Wed, 12 November 2003 11:11  |
Nina Villegas
Messages: 13
Registered: November 2003
|
Junior Member |
|
|
On our mouse-click trigger on a button we are trying to execute an insert statement as shown below:
BEGIN
ctime := sysdate;
squote := chr(39);
ctest := 'INSERT INTO
(USERID, DATE_TIME, SCREEN) VALUES (' || squote || :GLOBAL.userid || squote || ', ' || squote || ctime || squote || ', ' || squote || 'Maintenance'|| squote || ' )';
FORMS_DDL(ctest);
IF Form_Success THEN
MESSAGE('OK');
ELSE
MESSAGE(DBMS_ERROR_TEXT);
END IF;
END;
On running this script, we get no errors but nothing gets inserted into our table.
Any help to fix this problem would be appreciated.
|
|
|
|
|
|
| Re: using forms_ddl to insert [message #83662 is a reply to message #83636] |
Thu, 20 November 2003 21:32  |
Rengaprabhu
Messages: 18
Registered: August 2002
|
Junior Member |
|
|
|
Instead of you using FORMS_DDL try to do commit or finally you can commit_form, you are trying to commit the particular procedure first, but the insert statement holds the values in buffer, no need to worry to commit at the end.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
