I created the oracle connection inside named connection window. and tested, its good. But when i use the same connection for sql executor i am getting the following error
Connecting to ORACLE database `EGIS_T' with user name of `EGIS' and password of `***'
Error connecting to Oracle database: message was `ORA-12154: TNS:could not resolve the connect identifier specified'. (serverType=`ORACLE8i', serverName=`EGIS_T', userName=`EGIS', password=`***', dbname=`')
ORACLE Reader: Using Oracle Reader to read tables from database `', server type `ORACLE8i', server name `EGIS_T', user name `EGIS', password `***'
ORACLE Reader:
fme is not mapping the connection name to connection object.
where is the problem ?