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

Home -> Community -> Usenet -> c.d.o.server -> Procedure Problem

Procedure Problem

From: <dinyar_at_rocketmail.com>
Date: 1997/12/25
Message-ID: <883113245.32899084@dejanews.com>#1/1

Hi,
I have created a proceudre
this is the procedure

procedure on_suppmst (suppcd IN po.suppmst.suppcode%type, supp_row out po.suppmst%rowtype, supp_found out boolean) is begin
supp_found:=true;
select * into supp_row from po.suppmst
where suppcode = suppcd;

exception

   when no_data_found then
    supp_found :=false;
    supp_row := NULL;
end;

I get the following error
"PL/SQL CHECK #22219 PLEASE INFORM YOUR ORACLE REPRESENTATIVE" I have checked the error mesage manual the number does not exist Can anyone help
Thanks in Advance
-Dinyar

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Thu Dec 25 1997 - 00:00:00 CST

Original text of this message

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