Re: Stored Procedures

I think the blank lines or (breaks as it was referred) are Ok.

The problem is () around the procedurre name. Take those out, since you are not passing any parmaters to it.

That will do it.

oracleguru_at_mailcity.com

Alexey M. Reshetov <real_at_kpbank.ru> wrote in article <6pm20q$fp$2_at_home.kpbank.ru>...
> Gocha Mchedlishvili (gocham_at_mci2000.com) wrote:
> : Hi!
>
> : I'm sure it sounds silly, but I have a following problem:
>
> : When I create a simple SP like:
>
> : CREATE PROCEDURE PR1()
> : AS
> : BEGIN
>
> : INSERT INTO TB1(FIELD1) VALUES ('value');
>
> : END;
>
> : and later trying to run it
>
> : EXECUTE PR1
>
> : I'm getting error message: Not valid SQL Command
>
> : I'm using ORACLE 7.3 and SQL Navigator 3.2
> : Any help would be greatly appreciated
> : Thanks
>
> : Gocha
>
>
> You should use it without brakes:
>
> CREATE PROCEDURE PR1
> AS
> BEGIN
> INSERT INTO TB1(FIELD1) VALUES ('value');
> END;
> /
>
> ____________________________________________________
> Alexey Reshetov
> real_at_kpbank.ru
>
>
Received on Wed Jul 29 1998 - 08:47:51 CDT