Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Printing PL/SQL record values to screen

SamBJul 16 2007 — edited Jul 17 2007

Is there a way to print values of a plsql record to the screen (dbms_output) without knowing the names or number of columns?

i.e.

declare
some_record some_cursor%rowtype;
begin
For each column in some_record loop
dbms_output.put_line(column name || ' ' ||column value);
end loop when no more columns;
end;

Message was edited by:
SamB

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2007
Added on Jul 16 2007
6 comments
4,123 views