Re: Any way to capture spatial bind data?
Date: Fri, 8 Dec 2023 10:26:47 +0300
Message-ID: <CAOW9pnSkw9-5JkBQ6eQg=eLo2Prz_kBt-hjV7inmeeLZQ-DN0Q_at_mail.gmail.com>
Hi Jonathan;
Error is like below:
Database version is 19.20.
ORA-03137: malformed TTC packet from client rejected[3146] [94] [] [] [] []
[] []
sql statement is like below: (fully replaced)
V_EW_ORG_DEVICE.GEO column type is SDO_GEOMETRY
Error is thrown according to the* :1* parameter bind value. But this value
is not logged in the application layer. And i am curious about is there a
way to capture SPATIAL bind data.
Thanks.
Osman DINC <dinch.osman_at_gmail.com>, 7 Ara 2023 Per, 20:19 tarihinde şunu
yazdı:
>
ORA-03146: invalid buffer length for TTC field.
SELECT V_EW_ORG_DEVICE.DEVICE_ID,
V_EW_ORG_DEVICE.PAR_ORG,
V_EW_ORG_DEVICE.ORG_ID,
V_EW_ORG_DEVICE.ORG_NAME,
V_EW_ORG_DEVICE.SYS_ID,
V_EW_ORG_DEVICE.SYS_NAME,
V_EW_ORG_DEVICE.SYS_TASK_TYPE,
V_EW_ORG_DEVICE.SYS_TASK,
V_EW_ORG_DEVICE.SYS_DESC,
V_EW_ORG_DEVICE.SYS_SER_NU,
V_EW_ORG_DEVICE.OP1,
V_EW_ORG_DEVICE.OP1_NAME,
V_EW_ORG_DEVICE.OP1_PHONE,
V_EW_ORG_DEVICE.OP1_ORG,
V_EW_ORG_DEVICE.OP2,
V_EW_ORG_DEVICE.OP2_NAME,
V_EW_ORG_DEVICE.OP2_PHONE,
V_EW_ORG_DEVICE.OP2_ORG,
V_EW_ORG_DEVICE.TRANS,
V_EW_ORG_DEVICE.GEOG_LATI,
V_EW_ORG_DEVICE.GEOG_LONG,
V_EW_ORG_DEVICE.DEC_LATI,
V_EW_ORG_DEVICE.DEC_LONG,
V_EW_ORG_DEVICE.GEO
FROM V_EW_ORG_DEVICE
WHERE ( V_EW_ORG_DEVICE.SYS_NAME = 'ORANGE A'
OR V_EW_ORG_DEVICE.SYS_NAME = 'ORANGE B')
AND (sdo_filter (V_EW_ORG_DEVICE.GEO, *:1*) = 'TRUE');
>
> Hi Jonathan,
>
> I will supply more information tomorrow morning.
>
> Regards
> Osman Dinç
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 08 2023 - 08:26:47 CET