Urgent: Invalid Identifier
Posted in 2004
Dear Sir,
I have IDS7.30 with 100GB database on one solaris2.6 server. I have one more
solaris8 server where I have installed oracle reporting tool. I have done
connectity of these two with csdk2.8 transpherent gateway.
Now while accessing informix database I am able to retrive all the tables
with field name. But when I try to access table in oracle with * ( ie.
select * from "xyz"@to; ), system is giving me following error
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Transparent gateway for INFORMIX]Error -217: Column (h) not found in
any table in the query (or SLV is undefined).
ORA-02063: preceding 2 lines from TODAY
Then I tried to access same table, field by field and then came to know that
there is a field named hash13 with datatype char(16) is giving problem with
error "00904: "hash13": invalid identifier"
My table is unchanged still this problem is occuring. But the thing is I can
see the column hash13 at database but unable to see the column at
application level.
Regards,
Ruturaj
This message (including any attachments) contains confidential information intended for a specific individual recipient and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.
sending to informix-list