Has the following stored procedure
Declare
Wktgeom CLOB.
The BEGIN
Wktgeom:=SDO_UTIL TO_WKTGEOMETRY (SDO_GEOMETRY (2003, NULL, NULL, SDO_ELEM_INFO_ARRAY (5, 1100
2,1,2,2,5,2,1), SDO_ORDINATE_ARRAY (,0,2,0,1,1,0,0,1, 1-1)));
The END;
I passed the accounted interface to perform the procedure, but now I want to remove this wktgeom accounted through interface variable content, didn't think of a good way to solve this problem, asking our great god, if there is a good solution or where I am currently thinking needs to be improved,
CodePudding user response:
Using the function, return wktgeom
The create or replace function f_test
Return clob
Is
Wktgeom clob.
The begin
Wktgeom:=sdo_util to_wktgeometry (sdo_geometry (2003, null, null, sdo_elem_info_array 5,2,1,2,2,5,2,1 (1100), sdo_ordinate_array (,0,2,0,1,1,0,0,1, 1-1)));
Return wktgeom;
end;