Re: first PL/SQL procedure ...why is "statement ignored"

From: cumin <jkilbourne_at_gmail.com>
Date: 5 Oct 2005 12:56:48 -0700
Message-ID: <1128542207.990283.120760@g43g2000cwa.googlegroups.com>

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 Received on Wed Oct 05 2005 - 14:56:48 CDT