How To Add Quote Based Query In SystemSQL
(Doc ID 2302907.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle WebCenter Sites - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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 ?
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