My Oracle Support Banner

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:

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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