My Oracle Support Banner

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

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
Goal
Solution


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