TABLE OF CONTENTS

PACKAGE/DEBUG [ Modules ]

[ Top ] [ Modules ]

NAME

    DEBUG - 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 complext types for output during debugging eg dbms_output.

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2017 - Original coding.

COPYRIGHT

    (c) 2005-2018 by TheSpatialDBAdvisor/Simon Greener

SOURCE

  Procedure PrintPoint( p_point    in mdsys.sdo_point_type,
                        p_round    in number default 3,
                        p_prefix   in varchar2 default null,
                        p_linefeed in boolean default false);

  Procedure PrintPoint( p_point    in mdsys.vertex_type,
                        p_round    in number default 3,
                        p_prefix   in varchar2 default null,
                        p_linefeed in boolean default false);

  Procedure PrintPoint( p_point    in &&INSTALL_SCHEMA..T_Vertex,
                        p_round    in number default 3,
                        p_prefix   in varchar2 default null,
                        p_linefeed in boolean default false);

  Procedure PrintGeom(  p_geom        in mdsys.sdo_geometry,
                        p_round       in number default 3,
                        p_linefeed    in boolean default false,
                        p_suffix_text in varchar2 default null);

  Procedure PrintGeom(  p_geom        in &&INSTALL_SCHEMA..T_Geometry,
                        p_round       in number default 3,
                        p_linefeed    in boolean default false,
                        p_suffix_text in varchar2 default null);

  Function PrintGeom(   p_geom     in mdsys.sdo_geometry,
                        p_round    in number default 3,
                        p_linefeed in integer default 0,
                        p_prefix   in varchar2 default null,
                        p_relative in integer default 0)
    Return clob deterministic;

  Procedure PrintElemInfo( p_elem_info in mdsys.sdo_elem_info_array,
                           p_linefeed  in Boolean default false);

  Procedure PrintOrdinates(p_ordinates in mdsys.sdo_ordinate_array,
                           p_coordDim  in pls_integer default 2,
                           p_round     in pls_integer default 3,
                           p_linefeed  in Boolean default false);