Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't CREATE PROCEDURE
Pinne <pinne_at_pegit.se> wrote in message news:38131C3A.7E5351C7_at_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.
There is a missing semicolon at the end of your insert statement. Better to use CREATE OR REPLACE PROCEDURE anyway. Received on Sun Oct 24 1999 - 11:03:02 CDT