Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> first PL/SQL procedure ...why is "statement ignored"

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

From: cumin <jkilbourne_at_gmail.com>
Date: 5 Oct 2005 12:40:13 -0700
Message-ID: <1128541213.904840.49860@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 Received on Wed Oct 05 2005 - 14:40:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US