cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Sender Error

Former Member
0 Kudos
41

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


Accepted Solutions (0)

Answers (1)

Answers (1)

former_member184720
Active Contributor
0 Kudos

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
0 Kudos

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

But when executed directly in data base it works

nabendu_sen
Active Contributor
0 Kudos

Hi Sourabh,

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

Regards,

Nabendu.