McCormick
12-15-2004, 10:39 AM
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
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