BlockInsertWithoutcommitThis is a featured page

Moving data in Form blocks to database without commit This is an useful features on Developer 6i, some times you need to insert the data in the database without saving the data definitively.

The command is POST;

But you must analyze if you need to clear that information posted:
  • If you don’t save the record, and move to another record
  • If you go to ENTER-QUERY mode
  • Etc.

To delete that posted data, you must execute the following command.

DECLARE
sp_name VARCHAR2(80);
BEGIN
sp_name := Get_Application_Property(SAVEPOINT_NAME);
Issue_Rollback(sp_name);
END;


No user avatar
juancarlosreyesp
Latest page update: made by juancarlosreyesp , Sep 26 2008, 11:36 AM EDT (about this update About This Update juancarlosreyesp Edited by juancarlosreyesp

87 words added

view changes

- complete history)
Keyword tags: None
More Info: links to this page
There are no threads for this page.  Be the first to start a new thread.