Re: Help!!! Pl/SQL and Report

Why not use a 'fixed name' temp table which you refer to in your main query in your report?

The fixed temp table can have a column called user_id to distinguish between different users running queries (or allocate a unique ID). On the after report trigger, delete from this temp table where user_id = <the users user id>.

I used this method a lot.

Also in Reports 3, i think you can pass a ref_cursor to a query. Never tried it though.

Mark

<tianh_at_my-deja.com> wrote in message news:7se4n9$q2j$1_at_nnrp1.deja.com...
> I need to create a report, which has to incorporate the PL/SQL to
> process the data.
>
> But if in the procedure, either I use Cursor Or Tempory Table to store
> the data which has been process, How can I refer to those data stored in
> Cursor or Temp_Table? ----The report need to retrieve the data from
> Temp_table or Cursor.
>
> I am anxious to get help, and appreciate very much for any advice.
>
> Helen
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Sep 28 1999 - 10:15:12 CEST