JDBC Sender Error

[Former Member]

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

[former_member184720]

if you don't have any update statement just keep it as <TEST> .

What happens when you execute the query?

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

[Former Member]

This query also gives the same error in PI ORA-00911, invalid character

But when executed directly in data base it works

[nabendu_sen]

Hi Sourabh,

Remove ; (Semi colon) from your query and check once. Remove Semi colon at the end of the SELECT statement.

Regards,

Nabendu.