SDO_GEOM.SDO_MBR Function Call Errors Out with ORA-02315: Incorrect Number of Arguments for Default Constructor (Doc ID 1681749.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Getting error while running below code -

SELECT a.geometry_p.sdo_point.x, a.geometry_p.sdo_point.y, SDO_GEOM.sdo_mbr (a.geometry_a)
INTO starting_x, starting_y, temp_geom
FROM c_path_node a
WHERE copathn_id = cpn_pks (item);

Gives: [Error] ORA-02315 (5070: 17): PL/SQL: ORA-02315: incorrect number of arguments for default constructor ( for SDO_GEOM.sdo_mbr (a.geometry_a))

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms