Re: Any way to capture spatial bind data?

• I traced with 10056,10043 and also tried errorstack for ORA-3137 and could not capture bind values in trace files.

Hi all;

I am trying to troubleshoot an ORA-3137 [3146] error.

I have read Doc ID 31625618.8. In my case,it is a select statement not a dml. I guess, Most probably, it is a client driver issue but i want to diagnose more if possible. Client application is using an universal data access component (UniDAC for Delphi) and application does not have a detailed logging mechanism.

Problematic sql statement is working sometimes and for some bind values, it gets ORA-3137. We are using ASO(Advanced Security Option) and cursor_sharing is forced. Original statement is using literals.

Question is : I wonder if there is any way to capture spatial bind data? Its datatype is 121.

According to the v$sql_bind_capture documentation in Database Reference,

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-SQL_BIND_CAPTURE.html#GUID-D353F4BE-5943-4F5B-A99B-BC9505E9579C

"Bind values are not always captured for this view. Bind values are displayed by this view only when the type of the bind variable is simple (this excludes LONG, LOB, and ADT data types) and when the bind variable is used in the WHERE or HAVING clauses of the SQL statement."

I traced with 10056,10043 and also tried errorstack for ORA-3137 and could not capture bind values in trace files.

Regards,

Osman D©NÇ

--
http://www.freelists.org/webpage/oracle-l