Re: Any way to capture spatial bind data?
From: Osman DINC <dinch.osman_at_gmail.com>
Date: Fri, 8 Dec 2023 10:26:47 +0300
Message-ID: <CAOW9pnSkw9-5JkBQ6eQg=eLo2Prz_kBt-hjV7inmeeLZQ-DN0Q_at_mail.gmail.com>
Date: Fri, 8 Dec 2023 10:26:47 +0300
Message-ID: <CAOW9pnSkw9-5JkBQ6eQg=eLo2Prz_kBt-hjV7inmeeLZQ-DN0Q_at_mail.gmail.com>
sql statement is like below: (fully replaced)
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');
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ı:
>
>
> 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