New answers tagged

0

Slightly rewritten (so that number of rows is fetched out of the cursor): SQL> create or replace procedure find_table_with_column_value 2 (arg_column_name in varchar2, arg_column_value in varchar2) 3 is 4 v_rowcount number; 5 v_sql_statement varchar2(4000); 6 begin 7 for l in (select owner || '.' || table_name as owner_table ...


0

It seems like the only way to do this is by creating a custom type and a custom function: CREATE TYPE vertex_type_cust AS object ( x NUMBER, y NUMBER, z NUMBER, w NUMBER, id NUMBER ); CREATE TYPE vertex_set_type_cust AS TABLE OF vertex_type_cust; CREATE OR replace FUNCTION getvertices_cust(geometry mdsys.sdo_geometry) RETURN ...


Top 50 recent answers are included