[freetds] ORA-00904: "D_TIME": invalid identifier

=?gb2312?B?p6mn06fWp+Kn1qfTIKejp9qn5KfRp92n2qfbIKeip+Cn4qfap+On4KfTp9o=?= =?gb2312?B?p6mn06fWp+Kn1qfTIKejp9qn5KfRp92n2qfbIKeip+Cn4qfap+On4KfTp9o=?=
Wed Jun 22 02:50:29 EDT 2005


Hello Wei Jiang,
1)By default oracle uses upper cased column name notation and it can be =
a cornerstone of your problem.
You should try to rewrite select in case-sensitive style:
select "Exact_CoLuMn_NaMe" from record at hscwa
If you doubt in translated HS case-sensitive column names, try this:

select column_name=20
from dba_tab_columns at hscwa
where lower(table_name) like 'record'

2)set suitable db
The 'record' table should be accessible from database noted in ODBCINI / =
HS_FDS_CONNECT_INFO or you should assign it explicitly before select.
DECLARE=20
   val  VARCHAR2(100);=20
   c    INTEGER;=20
begin
 c:=3D DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE at hscwa('use _bla_bla_bla_');
end;=20

Sincerely yours.=20

------------------------------------------------------------=20
 Vitaly Zverev, Oracle Applications DBA,
   Genesis Ltd., St.Petersburg, Russia=20
>>>>>> Tel : +7(812) 329-5689  <<<<<<
>>>>>>>> http://www.gen.ru <<<<<<<<



-----Original Message-----
From: freetds-bounces at lists.ibiblio.org =
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Wei Jiang
Sent: Wednesday, June 22, 2005 5:12 AM
To: freetds at lists.ibiblio.org
Subject: [freetds] ORA-00904: "D_TIME": invalid identifier


I has configured oracle HS, unixODBC and freetds, I
can run isql and tsql to test the connection, I can
run "select * from record at hscwa;" to recive each line
in table record with sqlplus, and I know the field
contains "d_time", so I type "select d_time from record at hscwa;",  but I =
got this error messaes:
"ORA-00904: "D_TIME": invalid identifier".=20
Could anyone help me?
Thanks=20


=09

=09
	=09
___________________________________________________________=20
=D1=C5=BB=A2=C3=E2=B7=D1G=D3=CA=CF=E4=A3=AD=D6=D0=B9=FA=B5=DA=D2=BB=BE=F8=
=CE=DE=C0=AC=BB=F8=D3=CA=BC=FE=C9=A7=C8=C5=B3=AC=B4=F3=D3=CA=CF=E4
http://cn.mail.yahoo.com/?id=3D77071

_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org =
http://lists.ibiblio.org/mailman/listinfo/freetds


More information about the FreeTDS mailing list