Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Procedure Problem
dinyar_at_rocketmail.com wrote:
>
> 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
Hi,
maybe it depends on the ora-version you use. Oracle for NT v. 7.3 had a bug in the SQL-compiler wich is eliminated in 7.334. We had strange results compiling and using packages, which were gone after upgrading.
-- Regards Matthias Gresz :-)Received on Tue Dec 30 1997 - 00:00:00 CST