Cast object to CLOB
For mockup purposes I have a logging table and a testdata table.
I have a user defined type, lets say coordinate which has two points.
I want to save this user defned type in a table as a CLOB. Is this possible? The type itself cannot be changed.
The other way around works. I use EXECUTE IMMEDIATE to accomplish this. Now only needed is from TYPE => CLOB.
l_coordinate COORDINATE_T;
l_result CLOB;
BEGIN
SELECT result
INTO l_result
FROM mck_data
WHERE parameters = key
AND type = l_type;
EXECUTE IMMEDIATE 'SELECT ' || l_resultaat || ' FROM DUAL ' INTO l_als_locatie ;
return l_als_locatie;
..