How To Add Quote Based Query In SystemSQL
(Doc ID 2302907.1)
Last updated on DECEMBER 04, 2019
Applies to:
Oracle WebCenter Sites - Version 11.1.1.8.0 and laterInformation 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 |