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

Home -> Community -> Usenet -> c.d.o.misc -> Can't CREATE PROCEDURE

Can't CREATE PROCEDURE

From: Pinne <pinne_at_pegit.se>
Date: Sun, 24 Oct 1999 16:48:26 +0200
Message-ID: <38131C3A.7E5351C7@pegit.se>


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

Original text of this message

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