Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> first PL/SQL procedure ...why is "statement ignored"
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
![]() |
![]() |