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 -> Re: Procedure Problem - Once Again

Re: Procedure Problem - Once Again

From: J L Joslin <jjoslin_at_ibm.net>
Date: 1997/12/28
Message-ID: <34a5a909.37020859@news-s01.ca.us.ibm.net>#1/1

Dinyar,

        Error number 22219 is an internal procedural language generated error. The error numbers from 22000 to 22999 are reserved for user generated messages. I strongly recommend that you contact Oracle Worldwide Customer Support regarding this error.

Jim Joslin, Principal Consultant
Oracle Consulting Services - Florida Technology Practice


On Fri, 26 Dec 1997 12:01:05 -0600, Dinyar Ghyara <dinyar_at_rocketmail.com> wrote:

>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 Sun Dec 28 1997 - 00:00:00 CST

Original text of this message

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