I have written a stored procedure , in which i have included 4-level nested cursors. fetching values each depending on the output of other ( previous ) cursor,
in result pane of query analyzer, it is showing every value correctly , but is not getting updated in the desired table

at end after deallocating the cursor , do we need to write any update statement
suggest me



CONFIDENTIALITY NOTICE: This e-mail and its attachments may contain PRIVILEGED and CONFIDENTIAL INFORMATION and/or PROTECTED PATIENT HEALTH INFORMATION intended solely for the use of Tranquilmoney Inc. it's clients and the recipient(s) named above. If you are not the intended recipient, or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any review, dissemination, distribution, printing, or copying of this e-mail message and/or any attachments is strictly prohibited. If you have received this transmission in error, please notify the sender immediately and permanently delete this e-mail [shred the document] and any attachments.




Oracle LazyDBA home page