Re: Help with procedure
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 20 Apr 2002 14:49:55 -0700
Message-ID: <a20d28ee.0204201349.5e0f0f83_at_posting.google.com>
Date: 20 Apr 2002 14:49:55 -0700
Message-ID: <a20d28ee.0204201349.5e0f0f83_at_posting.google.com>
oracle_at_redmande.com (Oracle Dev) wrote in message news:<a823627f.0204201026.6f242abe_at_posting.google.com>...
> Hi
>
> I am creating a simple procedure.
>
> Create or replace procedure carga
> (numemp in number)
> as
> begin
> Insert into temp
> Select empno from scott.emp
> where empno =:numemp;
> End;
>
>
> but this give me compilation erros. Where can I see this errors and what is wrong?
>
> Thank you
Please remove the : in front of numemp
Regards
Sybrand Bakker
Senior Oracle DBA
Received on Sat Apr 20 2002 - 23:49:55 CEST