Re: Oracle reports 10g and stored proc (ref cursor)

Thanks Daniel - So far things are working pretty well. However, I appreciate the offer to allow me to contact you if I need further help.

Have a great day

Joe
DA Morgan wrote:
> joet11_at_comcast.net wrote:
>
> > I did find the following approach which appears to work. Any
comments
> > as to whether this is the correct approach would be appreciated:
> > I created a query in the data model as follows: (it calls the
procedure
> > P_TEST which exists in the db and the ref cursor is defined in the
> > package PKG_TEST)
> >
> > function QR_1RefCurDS return PKG_TEST.CursorTEST is
> > out_cursor PKG_TEST.CursorTEST;
> > begin
> > P_TEST(42020,OUT_CURSOR);
> > return OUT_CURSOR;
> > end;
> >
> >
> >
> > Thanks - Joe
> >
> >
> > joet11_at_comcast.net wrote:
> >
> >>Hi;
> >>
> >>We are looking at switching to Oracle Reports 10g from Crystal
> >
> > reports.
> >
> >> I am trying to migrate one of the Crystal reports. The Crystal
> >
> > report
> >
> >>gets its data input by calling an Oracle stored procedure (existing
> >
> > in
> >
> >>the DB) which returns a ref cursor.
> >>
> >>I'd like to use that same stored procedure to feed the Oracle
report.
> >>However, I can only find documentation which describes how to save
a
> >>procedure into an external library via the Oracle reports
> >>functionality. Then attach that external libray to other reports.
> >>
> >>I don't want to do that as there is no need to create it again. I
> >>simply want to call the existing stored procedure which already
> >
> > exists
> >
> >>in the DB and returns a ref cursor.
> >>
> >>Any help on how this can be done will be greatly appreciated.
> >>
> >>Thanks - Joe
>
> If you have any problems contact me off-line and I can put you in
touch
> with the person that guest lectures for me at the University of
> Washington on Oracle Reports.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)
Received on Fri Mar 04 2005 - 16:56:56 CET