| Collection to ref cursor [message #370003] |
Mon, 27 November 2000 01:29 |
Manoj Doerga
Messages: 1
Registered: November 2000
|
Junior Member |
|
|
Hello,
I am making reports in Infomaker 5 on Oracle 8.0. Infomaker has the possibilty to base reports on stored procedure, but expects a ref cursor as input. I have made a procedure which fills a temporary table and selects * from this table in a ref cursor and passes this to Infomaker. I thought it might be more efficient if I fill an in-memory collection in this procedure. My questions :
- would it be faster to use a collection ?
- is there a way to refer to a collection in a cursor in Oracle 8.0. I think in 8i you can use SELECT * FROM TABLE(CAST collection AS collection_type), is there a way to do this in 8.0 ?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
