Code:
SELECT *, cast(Field1 as char(6)), cast(Field1 as varchar2(10)) FROM myTable@JDeLink
Code:
SELECT * FROM myTable@JDeLink
hazeky
Last Activity: Mar 21 '13, 04:34 PM
Joined: Jan 15 '13
Location:
-
hazeky replied to Importing data from JDE char 3 via datalink into Oracle; "0xC14040... display in rowsin OracleI noticed all the number fields are correct, but the numeric fields are full of junk. I tried to cast the fields, but to no avail. I believe the problem starts before the import. I cannot even view the correct data.
Field1 “0xD4E4D5F0F1F0 F3F840404040404 0404040404040.. .”... -
hazeky replied to Importing data from JDE char 3 via datalink into Oracle; "0xC14040... display in rowsin OracleHi
I do not have an "Error". I am expecting a letter in the column, but Instead I have "0xC14040.. ." and it is wrong. Each row in the column has the same value "0xC14040.. ."Leave a comment:
-
hazeky started a topic Importing data from JDE char 3 via datalink into Oracle; "0xC14040... display in rowsin OracleImporting data from JDE char 3 via datalink into Oracle; "0xC14040... display in rows
Hi,
I am importing data from JDE char 3 field via datalink into an Oracle table. The field returns "0xC14040.. .". Does anyone know anything about this error, or how to view JDE char fields in Oracle?
Thanks
No activity results to display
Leave a comment: