Source of my job is SQL server table.It has a column whose datatype is Longvar binary (length-214748364).
The target table is oracle 9i.I am creating the table from job with same datatype.
The table is getting created with datatype LongRaw.But The job is getting aborted with error "Oracle datatype not presently supported".
Is datastage 7.5.2 not able to handle longvar binary?
Please suggest.
Longvarbinary datatype problem in a job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I can't help with the SQL Server question about LongVarBinary support. For the Oracle side, however, I would definitely avoid LONG or LONG RAW datatypes. They're really something you were stuck with in Oracle7 but since then have been deprecated and one should now use the 'new' LOB fields, introduced in 8i and enhanced since then.
Lots of information out there on the subject. Here's one such example that I Googled up. Hope it helps.
Lots of information out there on the subject. Here's one such example that I Googled up. Hope it helps.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers