My Oracle Support Banner

BMQL modify value containing a single quote character causes error (Doc ID 2688800.1)

Last updated on AUGUST 26, 2020

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 20 A and later
Information in this document applies to any platform.

Symptoms

When attempting to add a string with the ' character through bmql modify or update,
the following error occurs.

ERROR
-----------------------
BMQL Error: Encountered " "Test "" at line 1, column 44.
Was expecting one of:
  
  "WHERE" ...
  "," ...


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create a BMQL modify or update query where a sting is set including ' (apostrophe)
2. attempt to run query
3. observe the error

Example
-----------------------

modTest = bmql("modify TableName SET column1 = 'test'value'");

Changes

 upgraded to 20A where these queries are first introduced

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.