i think its better to use SPOOL than writing the procedure.
it will increase the performance speed awell compare to UTIL file.




"Shravan Kumar " <oracledba-ezmlmshield-x36019882.[Email address protected]

08/01/2006 10:19 AM

To

cc

Subject
error , suggest me







When executing a stored procedure, and trying to insert values into
table,
It is showing error as :: Resources are low , Some results are dropped.

No values are being inserted into the table..

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.





--------
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

ForwardSourceID:NT00003A2A
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you



Oracle LazyDBA home page