SAP DBTech JDBC: [7]: feature not supported: Unsupported parameter type:ST_GEOMETRY error while creating procedure

[Former Member]

Hello,

We get errors while activating the following procedure:

create PROCEDURE "GEO_SPACE"."USER1::DATA_INSERTION"

(

in client_id int,

in time_val SECONDDATE,

in location_id ST_GEOMETRY

)

    LANGUAGE SQLSCRIPT

    SQL SECURITY INVOKER

    --DEFAULT SCHEMA <default_schema_name>

    --READS SQL DATA

     AS

BEGIN

INSERT INTO "GEO_SPACE"."DATA_TABLE"(client_id,time_val,location_id)

VALUES(:client_id,:contact_no,:time_val,:location_id);

END;

Error Message:

"

Could not execute 'create PROCEDURE "GEO_SPACE"."USER1::DATA_INSERTION" ( in client_id int, ...'

SAP DBTech JDBC: [7]: feature not supported: Unsupported parameter type:ST_GEOMETRY: line 7 col 16 (at pos 169)

Could not execute 'create PROCEDURE "GEO_SPACE"."USER1::DATA_INSERTION" ( in client_id int,...'

SAP DBTech JDBC: [7]: feature not supported: Unsupported parameter type:ST_GEOMETRY: line 7 col 16 (at pos 169)

"

Here the data type ST_GEOMETRY is not supporting when we use it in a procedure and activate it.

But it works on following insertion statement:

INSERT INTO "GEO_SPACE"."DATA_TABLE" VALUES(1234,'2015-02-12', new ST_POINT(2,4));

Couldn't understand why we couldn't declare and use it in a procedure.  Kindly help me to resolve this.

Regards,

Antony Jerald.

[former_member185132]

Hi,

The error message is self-explanatory: ST_GEOMETRY isn't supported as a parameter in procedures, so you can't create a procedure that uses that data type.

Regards,

Suhas

[vishaldeep3000]

Error: feature not supported: [object Object] constant string is not allowed in Table type parameter: