| DOING A SELECT ON A PL/SQL TABLE [message #18892] |
Wed, 20 February 2002 06:48  |
Jarrod McReynolds
Messages: 3
Registered: February 2002
|
Junior Member |
|
|
I understand the concept that a PL/SQL TABLE is just a temp table. But inside of the procedure that created this temp table is there a way to do a select on this temp table.
Or is there a way to pass the contents of this temp table into a cursor, so that it can be used in a report that is calling the procedure.
here is the setup
I have a Crystal report. That is calling a procedure.
This procedure in return is calling a package.
I'm passing a Cursor from the procedure to the package, where the data is created and then back to the procedure, and then on to the report.
What I would like to be able to do is in the Package, I want to have more control over the data. I have 5 diffrent select statments that I have to do and then I want to check the information before putting it into this temp table. Each Select statment I will be going into the temp table and updating inforamtion before passing this to the report. But I can not find a way to get this temp table to the report.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
