How To Add Quote Based Query In SystemSQL
Last updated on SEPTEMBER 06, 2017
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 ?
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