Any Help, Its Urgent [message #81177] |
Mon, 20 January 2003 18:36 |
Vinod
Messages: 76 Registered: April 1999
|
Member |
|
|
I am executing a package from the Forms. We have insert statements inside the package.The package does not contain commit statement.Can i commit the insert statements from the Form and if so how to do this since i dont have any blocks based on a table in the form.
Any help appreciated
Thanks
Vinod
|
|
|
Re: Any Help, Its Urgent [message #81180 is a reply to message #81177] |
Tue, 21 January 2003 04:06 |
magnetic
Messages: 324 Registered: January 2003
|
Senior Member |
|
|
a commit in de package would be the easiest wat since you are inserting there.
Another way to commit is:
use exec_sql builtin package
pass a sting='commit;' from form to the database after calling your stored procedure in the form.
See examples of using the builtin package in forms developer (pres F1)
|
|
|
|
|