One Star tpk
One Star

[resolved] Invalid Character constant in tOracleInput

Hi Team,
I have a SQL query and i try to execute in tOracleInput when i run the job it is throwing me an error "Invalid Character Constant".
The query which i execute is given below, please correct me what should be done to make it work correctly
"SELECT DISTINCT
'ws' || website_id LOCATION_ID
,'ws' || website_id WEBSITE_ID
,'"' || website_nm || '"' LOCATION_NAME
,0 YEAR_OPENED
,0 OPENING_PERIOD
,0 YEAR_CLOSED
,0 CLOSING_PERIOD
,'"' || website_nm || '"' ADDRESS
,0 STORE_AREA
FROM
edw.dim_website_storefront
WHERE website_nm NOT LIKE '%.ca'
UNION
SELECT DISTINCT
'dc' || facility LOCATION_ID
,'dc' || facility WEBSITE_ID
,'"' || substr(title,1,29) || '"' LOCATION_NAME
,0 YEAR_OPENED
,0 OPENING_PERIOD
,0 YEAR_CLOSED
,0 CLOSING_PERIOD
,'"' || substr(title,1,29) || '"' ADDRESS
,0 STORE_AREA
FROM public_bcs.warehouse_facility;"

Please help with a solution.
Thanks and Regards,
Pavan
1 ACCEPTED SOLUTION

Accepted Solutions
One Star tpk
One Star

Re: [resolved] Invalid Character constant in tOracleInput

Hi Pedro,
The Issue is resolved that error is because due to the Double Quotes in the query, i just put escape sequence \ where ever double quotes are present
Thanks and Regards,
Pavan
Hi Pavan
Please show us the entire error log on console.
Regards,
Pedro
2 REPLIES
One Star

Re: [resolved] Invalid Character constant in tOracleInput

Hi Pavan
Please show us the entire error log on console.
Regards,
Pedro
One Star tpk
One Star

Re: [resolved] Invalid Character constant in tOracleInput

Hi Pedro,
The Issue is resolved that error is because due to the Double Quotes in the query, i just put escape sequence \ where ever double quotes are present
Thanks and Regards,
Pavan
Hi Pavan
Please show us the entire error log on console.
Regards,
Pedro