topic [resolved] Invalid Character constant in tOracleInput in Talend Studio

[resolved] Invalid Character constant in tOracleInput

Anonymous — Thu, 28 Jun 2012 06:33:43 GMT

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

Re: [resolved] Invalid Character constant in tOracleInput

Anonymous — Thu, 28 Jun 2012 06:43:28 GMT

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

Re: [resolved] Invalid Character constant in tOracleInput

Anonymous — Fri, 29 Jun 2012 15:53:47 GMT

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