As per the requirement::

i need to fetch the values and insert it into the table, though i could find and fetch the values using stored procedure and cursors, i couldn't insert the values...

It is stating : could not find stored procedure


Server: Msg 2812, Level 16, State 62, Line 79
Could not find stored procedure 'update tblpat_History set Category='Circulation',CHKCAbdominal='True' where accountnumber='100000''.


inspite of writing stored procedure






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