TABLE OF CONTENTS

PACKAGE/PRINT [ Modules ]

[ Top ] [ Modules ]

NAME

    PRINT - Functions that can be used to create string versions of complex types for output during debugging eg dbms_output.

DESCRIPTION

    A package that publishes some functions that can be used to create string versions of complex types for output during debugging eg dbms_output.

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - August 2019 - Original coding.

COPYRIGHT

    (c) 2005-2019 by TheSpatialDBAdvisor/Simon Greener

SOURCE

  Function sdo_point_type( p_point in mdsys.sdo_point_type,
                           p_round in number default 3)
    Return varchar2 deterministic;

  Function Vertex_Type(p_point in mdsys.vertex_type,
                       p_round in number default 3)
    Return varchar2 deterministic;

  Function sdo_elem_info( p_elem_info in mdsys.sdo_elem_info_array )
    return varchar2 deterministic;

  Function sdo_ordinates(p_ordinates in mdsys.sdo_ordinate_array,
                         p_coordDim  in pls_integer default 2,
                         p_round     in pls_integer default 3)
    Return clob deterministic;

  Function sdo_geometry(p_geom  in mdsys.sdo_geometry,
                        p_round in number default 3)
    Return clob deterministic;