string to recordtype conversion [message #36360] |
Tue, 20 November 2001 05:30 |
Thiyagarajan
Messages: 9 Registered: October 2000
|
Junior Member |
|
|
hi is there any function to convert a given string to a record type .the string will be given as
%rowtype only.but it will be a string.is there any function to convert this into a recordtype datatype.thanks in advance.bye thiyagu.
----------------------------------------------------------------------
|
|
|
Re: string to recordtype conversion [message #36366 is a reply to message #36360] |
Wed, 21 November 2001 01:44 |
Giridhar
Messages: 38 Registered: May 2001
|
Member |
|
|
Hai thiyagarajan,
In DBMS_UTILITY builtin package,there are two subprograms named "COMMA_TO_TABLE" AND "TABLE_TO_COMMA". These subprograms take comma separated string and coverts the values to the TABLE.
Will it be sufficient for you?
HTH
Giridhar Kodakalla
----------------------------------------------------------------------
|
|
|