URGENT : PL /SQL ERROR MESSAGE

From: Laurent <L.Phelep_at_ex.ac.uk>
Date: 1998/02/16
Message-ID: <34E8B052.41C6_at_ex.ac.uk>#1/1

hi

[Quoted] while programming with SQLFORMS 3.0

I received the following error message :

 PL/SQL Check #22219. Please inform your Oracle Representative

Has naybody got an idea what the problem is ??????????

p.s. : my procedure is as following :

Procedure run_bills is
s_date char (9);
e_date char (9);
customernumb number (4);
cursor customerbill is
  select distinct customer_number from

OPS$CS95SCJ.customer                 
    where customer_number in        

  ((select customer_number from OPS$cs95scj.order_table     where order_date between :bill.start_date and :bill.end_date)     union
   (select customer_number from OPS$cs95scj.payment     where payment_date between :bill.start_date and :bill.end_date)   );
begin
open customerbill;
s_date := To_Char (:bill.start_date);
e_date := To_Char (:bill.end_date);
loop
  fetch customerbill into customernumb;
  exit when customerbill%notfound;
  host('sqlplus -s / _at_CODE_BILL '|| s_date || ' ' || e_date || ' ' ||  customernumb, NO_SCREEN);
  host( 'cat CustomerBill.txt >> TotalBills.txt'); end loop;
exit_form;
end;

Sorry if the code is messy or not very good but I am just beginning...

Thanx to send the answers by Email.......

-- 
Laurent PHELEP                                      		 /\
Third Year Student in Computer Science                		 \/
University of Exeter                                  	       <>  <>
Email : L.Phelep_at_ex.ac.uk     				         /\
http://www.dcs.exeter.ac.uk/ug/cs95/lp/             		/  \
                                                   	       /    \
Kenavo                                           	      / /\/\ \

Received on Mon Feb 16 1998 - 00:00:00 CET