Procedure Problem - Once Again

From: Dinyar Ghyara <dinyar_at_rocketmail.com>
Date: 1997/12/26
Message-ID: <883158702.841220104@dejanews.com>#1/1

Hi, I had posted this query earlier but I would like you all to go through this again - the problem is - the procedure which I am about to show you all, works perfectly from SQL plus, it is when incorporated in a D2K trigger or program unit is when it gives an error.

for those of you who would like to see the error already here goes PL/SQL CHECK #22219 PLEASE INFORM YOUR ORACLE REPRESENTATIVE for those of you who like to see a couple of examples of code which generate the error-read on I am going to give you two examples

---

example no. 1

---

Procedure on_suppmst(suppcd IN po.suppmst.suppcode%type, supp_row out po.suppmst%rowtpe, 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;

end

---

example no. 2

---

This has been coded in the When-button-pressed trigger

declare cursor ch_dtl_cursor is ( select gp_type_series, gp_no from si.challan_no from si.challan_dtl where err_flg = 2); ch_dtl_row ch_dtl_cur%rowtype;
Begin
open ch_dtl_cur;
loop
fetch ch_dtl_cur into ch_dtl_row;
exit when ch_dtl_cur%notfound;
end loop;
end;

---

I am getting the following error in D2K when I am compiling the code PL/SQL CHECK #22219 PLEASE INFORM YOUR ORACLE REPRESENTATIVE I looked up my server error messages guide, but there was no number #22219 What could be the problem.
Thanks in advance
-Dinyar

-------------------==== Posted via Deja News ====-----------------------

      http://www.dejanews.com/ Search, Read, Post to Usenet Received on Fri Dec 26 1997 - 00:00:00 CST