Accessing PL/SQL Tables from SQL*Plus [message #985] |
Mon, 18 March 2002 15:56 |
Hersel Ahdout
Messages: 8 Registered: March 2002
|
Junior Member |
|
|
How would you access a PL/SQL Table from SQL*Plus?
What type of Variable you define (Is it RefCursor?)
If so, how do you pass the reference of PL/SQL table to the cursor?
I would really appreciate if you can shed some light on this.
Hersel Ahdout
|
|
|
|
Re: Accessing PL/SQL Tables from SQL*Plus [message #995 is a reply to message #990] |
Tue, 19 March 2002 08:42 |
Hersel Ahdout
Messages: 8 Registered: March 2002
|
Junior Member |
|
|
Thanks for clarifying this.
I am using a pl/sql table to filter through records obtained through a Hierarchical Query. Unfortunately the INTERSECT checks for match on all elements and LEVEL is a Psudo Column.
So, the only option will be to take an examine the resultset and post them into a pl/sql table.
I was checking tabdemo.sql (Sample Table Demo), and it is using EXTEND, TABLE & CAST for dumping the pl/sql table results into a CURSOR. But, the EXTEND & CAST are gettig rejected.
Any Idea? Thanks for any help.
Hersel
|
|
|
|
Re: Accessing PL/SQL Tables from SQL*Plus [message #1006 is a reply to message #1001] |
Wed, 20 March 2002 10:48 |
Hersel Ahdout
Messages: 8 Registered: March 2002
|
Junior Member |
|
|
Thanks for all the help.
I resolved the problem by the use of a nested Query (As one of the select Table/Views) and resolved the problem.
My understabding was that PL/SQL tables were intended for the filtering and returning the results to an external client (using JDBC).
Now I realize how powerful "Select Query" in oracle is in comparison with SQL Server.
Hersel
|
|
|