Re: URGENT : PL /SQL ERROR MESSAGE

Laurent wrote:
>
> hi
>
> 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.......
>

The error was due to the redundant parenthesis in the select statement

I had this answer thanx to Oracle that was very prompt to answer my DBA who then told me .......

Thanks to all who answered me

-- 
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                                           	      / /\/\ \