dananrg@yahoo.com wrote:
> Daniel, I'm going to look for your code and try it out today. If in
> the mean time you want to post a snippet here, that would be great.
> Evidently I'm not the only one confused about accomplishing this task
> through PL/SQL.
>
> If it can be done, it would be great to post the code here for others
> to learn from.

Look at the following demo:
http://www.psoug.org/reference/dbms_sql.html

Note the defined data types.
Read through the various procedure names.

It isn't easy ... but it can be done unless I am totally
misunderstanding what you are trying to accomplish.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Mar 6, 5:16*am, dana...@yahoo.com wrote:
> Daniel, I'm going to look for your code and try it out today. If in
> the mean time you want to post a snippet here, that would be great.
> Evidently I'm not the only one confused about accomplishing this task
> through PL/SQL.
>
> If it can be done, it would be great to post the code here for others
> to learn from.

Dana,
As I said before, the only method I know of is to use :
DBMS_SQL with describe_columns parocedure.
Look at the examples:
1. http://www.oracle.com/technology/ora...03/042003.html
2. http://www.oracle.com/technology/ora.../o36plsql.html
search for :Obtaining the Names of Columns in a Dynamic Select

HTH
Thomas