Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Stored Procedures
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
![]() |
![]() |