OraFAQ Forum: Forms » Any Help, Its Urgent

Home » Developer & Programmer » Forms » Any Help, Its Urgent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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)

Report message to a moderator