cumin wrote:
> Michel Cadot wrote:
> > "cumin" <jkilbourne_at_gmail.com> a écrit dans le message de news: 1128541213.904840.49860_at_o13g2000cwo.googlegroups.com...
> > | My procedure starts like this:
> > |
> > | create or replace procedure insert_orphans (
> > | firstrel IN VARCHAR2
> > | , secondrel IN VARCHAR2
> > | )
> > | AS
> > | BEGIN
> > | insert into qa_mesg
> > | (id_1, id_2, mesg)
> > |
> > | ...big long select statement here..
> > |
> > |
> > | I get this error:
> > | 7/4 PL/SQL: SQL Statement ignored
> > |
> > | The table qa_mesg exists:
> > |
> > | sql> desc qa_mesg
> > | Name
> > | --------
> > | ID_1
> > | ID_2
> > | MESG
> > |
> >
> > And what gives the following?
> >
> > set role none
> > desc qa_mesg
> >
> > Regards
> > Michel Cadot
>
>
> JOHN_at_orcl> run
> 1* set role none
>
> Role set.
>
> JOHN_at_orcl> desc qa_mesg
> Name
> -----------------------
> ID_1
> ID_2
> MESG
I was missing a semicolon at the end of the select statement, but was
fooled into thinking teh error was near the beginning. It's fine now.
Received on Wed Oct 05 2005 - 15:25:00 CDT
