How To Add Quote Based Query In SystemSQL (Doc ID 2302907.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Goal

How to add a sql statement in SystemSQL table? Customer wants to add the following SQL statement: Select id from Publication where name='Variables.sitename' Variables.queryend
but it seems they need to pass the variable "sitename" value as input in single quotes like ics.SetVar("sitename","'avisports'"); but the following does not works --> ics.SetVar("sitename","avisports");

They checked the sites.log which gave this error --> [2017-08-24 11:41:01,301 IST] [ERROR] [http-bio-9080-exec-145] [] [fatwire.logging.cs.db] Failed to execute query SELECT id FROM Publication WHERE name = avisports for query siteidlist

customer wants to know the correct statement which has requires single quote in the SQL element of SystemSQL table ?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms