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!

Converting pl/sql structure (record) to a string

62152Mar 13 2002

I need to convert a structure to a string, does anyone know how to do this?

e.g.
TYPE Msg IS RECORD /* record to store message info */
(
record_type VARCHAR2(3),
field1 VARCHAR2(10),
my_dept_nbr dept.dept_nbr%TYPE);

My_Msg Msg;

My_Msg.record_type := 'ABC';
My_Msg.field1 := 'whatever';
My_Msg.my_dept_nbr := 13;

Now I want to assign My_Msg to a string!!!
????

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2002

Added on Mar 13 2002

5 comments

1,173 views