PL/SQL based Report

From: McCormick <mccormm_at_indy.net>
Date: 15 Dec 2004 10:39:36 -0800
Message-ID: <1103135976.726991.74060_at_f14g2000cwb.googlegroups.com>



I'm creating a Report with Oracle Reports 3.0 under Oracle 8.1.6.

Basically, what I want to do is create a Table of records (or some other type of array of records) in a PL/SQL package attached to the report and run on the After Parameter Form trigger. Then I want to dump those records, line by line, in a repeating frame on the Layout.

The problem I've run into is the Data Model. The SQL Query only see's SQL tables and other SQL objects. It doesn't see the tables I've defined in the Package Spec.

I tried creating a Ref Cursor Query, but the function that Opens the cursor for Select doesn't want to use a table of records as it's table.

Searching the web, it seems like I need to create an SQL table (or SQL Object CAST as a table), load it from the PL/SQL package, and then select from it in the Data Model. The problem there is that I don't want to leave the table laying around afterwards. Will I have trouble, even if using a Ref Cursor, referencing a table that doesn't exist at compile-time.

Basically, my question is this: How do I get an array of records from the PL/SQL package to a repeating frame in the layout. Thanks a ton!

     Mike McCormick Received on Wed Dec 15 2004 - 19:39:36 CET

Original text of this message