Re: Reports 10g and packages


"sybrandb" <sybrandb@xxxxxxxxx> wrote in message
news:1177667563.095503.82970@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Apr 26, 4:54 am, "Tony_Miller" <NoWayTo...@xxxxxxxxx> wrote:
I am in the midst of converting a few reports from Crystal Reports to
Oracle
10g reports. I have built a package to hold my code in the first report
and
the calling functions to get a ref cursor returned and such. However,
when
I try to move the code (package definition and body) into the database I
am
running against, reports seems to not know where the package I am calling
is..

I have read the online docs and such and do not see anywhere that it is
posted that you can't move the package code and type definition of the ref
cursor out of the report.

Any help here?

Oracle 10g Reports running on a Windows XP desktop machine. Attaching to
an
Oracle 10g database on a AIX box.

Thank you,

Tony Miller
UTMB/EHN

---------------------------------------------------------------------------­-----
I am using the free version of SPAMfighter for private users.
It has removed 83 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!

'Seems not to know' is too vague and calls for crystal balls.
Obviously, those have worn out over the years.

--
Sybrand Bakker
Senior Oracle DBA

Sorry Sybrand, I was too vague there. What I found is I needed to attach
the package code to the report and then build a small sql function to call a
function in the package to return the required data via a ref cursor (not my
desire, specs given by another)...

Thanks!

Tony Miller
UTMB/EHN



--------------------------------------------------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 83 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!


.

Relevant Pages

  • Re: Mantis package bombs
    ... piles of bug reports to deal with as some maintainers do. ... That's advice I've been giving volunteers ... installed the package last night and got it working (in a little over ...
    (Fedora)
  • Re: tutorial to use the BTS ?
    ... debbugs - The bug tracking system based on the active Debian BTS ... devscripts - Scripts to make the life of a Debian Package maintainer easier ... reports bugs in the Debian distribution ...
    (Debian-User)
  • Re: Package to CD Woes
    ... She reports the same problem. ... If that doesn't do the trick, see if Package to Folder and then burning ... the PowerPoint Viewer opens and she sees her presentation files. ...
    (microsoft.public.powerpoint)
  • Re: What is more detailled than $^O ?
    ... Just because it's Red Hat doesn't mean it has package X, ... If one is writing an installer, it might be useful to know if one is ... helpful ("I can't find libfoo, since you are on a Redhat system, it is ... something you frequently want to include in reports of some kind: ...
    (comp.lang.perl.misc)
  • Reports 10g and packages
    ... I am in the midst of converting a few reports from Crystal Reports to Oracle ... I try to move the code (package definition and body) into the database I am ... It has removed 83 spam emails to date. ...
    (comp.databases.oracle.tools)