Link to home
Start Free TrialLog in
Avatar of lawlkl
lawlkl

asked on

Crystal Report v10 - report off Oracle 7.3.4 stored procedure

Dear Experts,

I have an Oracle 7.3.4 database still in production.
And I use crystal report v10 to get return sets from a stored procedure.
According to the menu, cr v10 does not support oracle 7.
How can I get rid of this?
I am using Oracle 8.1.7 client.

Thanks,

ASKER CERTIFIED SOLUTION
Avatar of bdreed35
bdreed35
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ebolek
ebolek

here is an article about cr10 and oracle 7
http://support.businessobjects.com/library/kbase/articles/c2016043.asp 
However vb.net version doesnt support oracle native driver
http://support.businessobjects.com/library/kbase/articles/c2011465.asp 

Regards
Emre
Avatar of lawlkl

ASKER

I have tried and created a DEMO ref cursor SP on both Oracle 7.3.4DB and 8.1.7DB.
I can successfully add the demo SP to CR10 when connecting to 8.1.7DB via native 8.1.7 client.
But I cannot do it on 7.3.4DB.  CR10 gives an error "Services requested by client not available on server."

The code of SP is:

REMARK Ref Cursor Demo
create or replace package t_product as
type t_product_rec is record
 (product_code b_product.product_code%type,
  bar_code     b_product.bar_code%type);

type t_product_type is ref cursor return t_product_rec;

procedure t_product_report (io_product_cur in out t_product_type);
end;
/
create or replace package body t_product as
procedure t_product_report (io_product_cur in out t_product_type) is
begin
 open io_product_cur for
   select product_code, bar_code from b_product
     where season_serial_no='302';
end;
end;
/

Do you know why?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial