Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: about storing PL/SQL block....newbie here

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

From: Eddie <edawad_at_hotmail.com>
Date: 2000/04/13
Message-ID: <lMqJ4.59693$QJ3.7224402@dfiatx1-snr1.gtei.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US