JDBC Sender Error

20 Views

Dear All

I am working on a JDBC to file scenario and facing following problem

While executing following select statement error I got ORA-00911, invalid character error in the channel

But when executed directly on DB its working

SELECT DISTINCT LKP.CORPCODE,'"'||LKP.ECOM_CORP_DESC||'"' CORPNAME,LKP.CORPID,LKP.CORPTYPE FROM LKP_CORPCODE LKP;

Seeing this I modified the query to this but reslt was same error

SELECT DISTINCT LKP.CORPCODE,LKP.CORPNAME,LKP.CORPID,LKP.CORPTYPE FROM LKP_CORPCODE LKP;

I further modifed the statement to following only to end up with same error again

SELECT DISTINCT CORPCODE,CORPNAME,CORPID,CORPTYPE FROM LKP_CORPCODE;

Please note that I am not using any Update query and the processing mode is Read-Committed

Could you suggest what am I missing here

Sourabh