How to Use the midstream mark in Oracle

The most commonly used cursor operation is to Perform Batch modification or batch deletion operations in the stored procedure. For example, after deleting a master table record, you can execute a stored procedure to delete the detailed records corresponding to the record. Or modify the data of a table and then write the data of another table. This is often used in ERP software development. For example, the actual lifting weight on the contract should be reversed after the warehouse picking and submitting a single instance, which should also be supported by a good database design.

The following describes how to use a cursor in an oracle stored procedure:

1. Procedure proc_fee_bymaindel (p_mainid in varchar2)
2. Is
3. -- ID of the pre-deletion ticket
4. N_feeid varchar2 (32 );
6. Cursor cur
7. Is
8. Select feeid
9. From efi_feeadjustsubline
10. Where isdel = 0 and mainid = hextoraw (p_mainid );
11. Begin
12. For cur_result in cur
13. Loop
14. Begin
15. N_feeid: = cur_result.feeid;
16. Proc_fee_del (n_feeid );
17. Exception
18. When others
19. Then-insert an error
20. -- Assign values to the return value
21. Raise_application_error (-20000,
22. 'Fee deletion error! '
23. | Sqlerrm
24. );
25. Goto proc_end;
26. End;
27. End loop;
29. <Proc_end>
30. NULL;
31. End proc_fee_bymaindel;