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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 5 Oct 2005 21:48:17 +0200
Message-ID: <43442dd9$0$7917$636a15ce@news.free.fr>

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