Re: How to build a report using a stored procedure
From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Tue, 03 Jun 2003 21:45:53 GMT
Message-ID: <MPG.1946b6e89d52cc949897a0_at_news.la.sbcglobal.net>
Date: Tue, 03 Jun 2003 21:45:53 GMT
Message-ID: <MPG.1946b6e89d52cc949897a0_at_news.la.sbcglobal.net>
wsp63002_at_yahoo.com said...
> How do you begin/create a new report off a stored procedure? I am so
> new to this that I just intalled the developer suite (9i) today and
> was asked to build a report already...we now use actuate.
>
> Any help would be great (I've been reading a lot from OTN, but not
> seeing anything concrete on procedures...just pl/sql).
>
> Regards,
>
> -abe
>
You might want to use the AskTom site for examples of ref cursors, which
return a "stream" of data from a procedure. For example, here's a
document that has lots of examples (will wrap, so copy/paste into your
browser):
http://asktom.oracle.com/pls/ask/f?p=4950:8:1090762::NO::F4950_P8 _DISPLAYID,F4950_P8_CRITERIA:246014735810,
-- /Karsten DBA > retired > DBAReceived on Tue Jun 03 2003 - 23:45:53 CEST