on 11-06-2014 2:21 PM
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
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.