Re: about storing PL/SQL block....newbie here

Since it is an anonymous block, I assume that you do not want to store it in the database. So, you can save it in a .sql file (using notepad or any text editor). You can then run the block from SQLPlus using this command: @filename.sql

Eddie.
Prabha Chidambaran <prabha_at_rcn.com> wrote in message news:8d2gvh$i50$1_at_bob.news.rcn.net...
> I want to store an annonymous block: For example
>
> declare
> ........
>
> begin
> ..............
>
> exception
> .......
> end;
>
> SQL>PL/SQl procedure successfully completed.
>
>
> How do I store this procedure and retrieve it?
>
> thanks so much,
> Prabha
>
>
Received on Thu Apr 13 2000 - 00:00:00 CDT