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 JULY 20, 2021

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.