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

Home -> Community -> Usenet -> c.d.o.server -> Stored Procedures

Stored Procedures

From: Gocha Mchedlishvili <gocham_at_mci2000.com>
Date: Wed, 29 Jul 1998 01:43:08 GMT
Message-ID: <M6vv1.86$__4.22313@news.mci2000.com>


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 Received on Tue Jul 28 1998 - 20:43:08 CDT

Original text of this message

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