RE: sql_text during parsing

Hello Nenad,
any chance with a process state dump (or error stack trace)?

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK<

> Noveljic Nenad <nenad.noveljic_at_vontobel.com> hat am 12.07.2021 17:25 geschrieben:
>
> Thanks!
>
> I got a part of SQL (it’s chopped)
>
> Any idea for getting the full text?
>
> SQL> oradebug setospid 17876
> Oracle pid: 107, Unix process pid: 17876, image: oracle_at_svdbp02p
> SQL> oradebug current_sql
> SELECT (CASE WHEN ((CASE WHEN (CASE WHEN (CASE WHEN (CASE WHEN (CASE WHEN (CASE WHEN (CASE WHEN (CASE WHEN ((CASE WHEN ((CASE WHEN (((CASE WHEN …
>
> The problem might be with the parsing of a nested case.
>
> Have to get the full text to experiment.

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