Hi,
Please use the find out if stored procedure exits or not .

Select Owner,Object_Name
From Dba_Objects
Where Object_Type = 'PROCEDURE'
And Object_Name = < Your Stored Procedure Name >
/

Cheers,
Biswajit
Union Bank Of India

-----Original Message-----
From: Shravan Kumar
[mailto:oracledba-ezmlmshield-x14108039.[Email address protected]
Sent: Wednesday, August 02, 2006 10:41 AM
To: LazyDBA Discussion
Subject: error:



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.





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page