Re: Stored Procedures

From: Alexey M. Reshetov <real_at_kpbank.ru>
Date: 29 Jul 1998 02:39:22 GMT
Message-ID: <6pm20q$fp$2@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 Tue Jul 28 1998 - 21:39:22 CDT