Re: Help with procedure
From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sat, 20 Apr 2002 18:58:25 GMT
Message-ID: <lTiw8.79986$G72.57681_at_sccrnsc01>
Date: Sat, 20 Apr 2002 18:58:25 GMT
Message-ID: <lTiw8.79986$G72.57681_at_sccrnsc01>
do show errors at the sqlplus prompt
Also what version of the db.
Does the insert statement work outside of the procedure?
Jim
"Oracle Dev" <oracle_at_redmande.com> 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
Received on Sat Apr 20 2002 - 20:58:25 CEST