I don't know much about oracle database, if inappropriate comments, please tell me more is burke,
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; 

CodePudding user response:

reference 1st floor qq646748739 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; 

I'm sorry to see stick on Monday, I have a try, thanks