Get PLS-00103 error when compiling procedure using q quote operator q'[]' (4238065)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Get PLS-00103 error when compiling procedure using q quote operator q'[]'
Description

When compiling a procedure that includes a q quote operator, q'[]', the following error is returned.

"[Error] PLS-00103 (5: 36): PLS-00103: Encountered the symbol ";END;" when expecting one of the following: * & = - + ; < / > at in is mod remainder not rem = and or like like2"
Cause

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

Whatever start/close characters are used for Q-quote, if the end character appears in the string followed (not even immediately) by a single quote, that is also part of the string, it incorrectly identifies the string.
Resolution

WORKAROUND #1:
Use new q quote characters. For example, change... `q'[ 'R[[:alnum:]]{5}' ]'` to `q'< 'R[[:alnum:]]{5}' >'`
In this case, ] is followed by a '. Something like this would also fail... `q'< 'R[[:alnum:>>{5}' >'` but this would work... `q'[ 'R[[:alnum:>>{5}' ]'`

WORKAROUND #2:
Compile using F5

WORKAROUND #3:
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