Re: .sql file

swapna.marri_at_gmail.com wrote:
> Hi,
> Thanks for you reply.
>
> If i ran the .sql file it will give you the output as
>
> **rows inserted
>
> procedure ran succesffuly
>
> etc etc
>
> now if i want to store this information to a oracle table,how should i
> go about it.
> this is needed as we will be scheduling this .sql file and so we can
> see the actions performed later by going to a table
>
> sappi
>

Just add another insert to your PL/SQL block to insert the value into a different table. Then you can query that value later. Another option is to use UTL_FILE to log the information to a log file, which can be viewed outside of the database.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown