Re: help

Hi

There are 2 ways to do this in SQL*Plus.

If you want to run an anonymous block in SQL*Plus without creating a stored procedure, all you need is

BEGIN -- at the beginning of your script and

END;     -- at the end of the script 
.            -- The period signifies end of anonymous block 
/            -- The slash runs the anonymous block

If you want to create a stored procedure then

create or replace procedure proc1 is
BEGIN
    Statements ....
END;
/

Then in SQL*Plus type:

execute proc1

I hope I have not missed anything.

Good luck !!!

Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com

basta said <basta_s_at_usa.net> wrote in article <Oz7H2.366$34.24_at_news.iam.net.ma>...
> hi,
> i m asking for how can i save or store the subroutins
> and the functions with oracle DBMS.
> and how can i use it with visual basic program with
> a distance application client / Server.
> the advantage of this solution is to reduce the time
> of access to a databse in distance.
> basta_s_at_usa.net
>
>
>
Received on Tue Mar 16 1999 - 12:06:45 CST