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

create or replace procedure <proc name> is <your PL/SQL block>
/

Then you can execute it with:
begin

   <proc name>;
end;
/
or:
exec <proc name>;

--
Have a nice day
Michel


Prabha Chidambaran <prabha_at_rcn.com> a écrit dans le message : 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

>

>