Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Can't CREATE PROCEDURE
Hi,
Having problems creating ANY sp
Example using SqlPlus:
=>
CREATE PROCEDURE ins_InhArt
AS
BEGIN
INSERT INTO InhArt(inh_id, artnr) VALUES(1, 'test')
END ins_InhArt;
<=
This allways fails with the message "procedure created with warnings"
When I try to "exec" it i get an error message complaining about line 1,
col 7.
The Schema is in SYSTEM, the user has been granted CREATE PROCEDURE.
Anyone Any hints ?
--
Björn-Åke Segrell / Pegit AB
Email:pinne_at_pegit.se
Url:http://www.pegit.se
Phone:+46-(0)8-56030220, Fax:+46-(0)8-56034353
Received on Sun Oct 24 1999 - 09:48:26 CDT
![]() |
![]() |