I create an ODBC connection to SQLite as in thread Creation db link to Sqlite?
file initdg4odbc.ora
#
# HS init parameters # HS_FDS_CONNECT_INFO = SQLITE2ORACLE
HS_FDS_TRACE_LEVEL = 4
#
# Environment variables required for the non-Oracle system # #set <envvar>=<value>
tnsnames.ora in network\admin:
dg4odbc = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1524)) (CONNECT_DATA=(SID=dg4odbc)) (HS=OK) )
listener.ora in the same folder:
SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (SID_NAME=dg4odbc) (ORACLE_HOME=D:\ora11\product\11.1.0\db_1) (PROGRAM=dg4odbc) ) )
I created an table in Sqlite:
create table table1(col integer)
insert into table1 values (1)
Using this the above configuration I successfully create a working database link:
create database link test using 'dg4odbc';
This SQL runs correctly:
Select * FROM table1@test;
the above select returns the correct values.
However I can't run the following SQL :
select col from table1@test;
00904. 00000 - "%s: invalid identifier"
Does anybody knows why can't I have named columns in the sql statement?