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,
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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%typ e,
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?
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%typ
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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