Body Type is changed when compiling a Body Type that uses a q quote operator q'[]' (4244345)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Body Type is changed when compiling a Body Type that uses a q quote operator q'[]'
Description

When compiling a Body Type that includes a q quote operator, q'[]', the Body Type is changed. The q and the start and close characters are removed.

For example...

q'~
with
inputs_
as (select --+ qb_name(get_nt_final_for_objectids_inputs)
:i_objectids in_objectids
,nvl(:i_compress,'Y') in_compress~';

...becomes...

'
with
inputs_
as (select --+ qb_name(get_nt_final_for_objectids_inputs)
:i_objectids in_objectids
,nvl(:i_compress,''Y'') in_compress';
Cause

This is a bug in one of our 3rd party components and has been confirmed by them.
Resolution

WORKAROUND:
Send SQL to SQL Plus to be compiled.
STATUS:
This issue is fixed in Toad for Oracle 13.1. This version can be downloaded from the downloads section of our website, which you can access by clicking here.
Defect ID

TOR-2479
Additional Information

The procedure compiles correctly in Toad 12.12.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title