Invalid Hex Number

srimitta · Post by **srimitta** » Mon Mar 20, 2006 4:08 pm

Hi Guys,

I am loading data from flat file into ORACLE table, It's returning error with

ORA-01465: invalid hex number

.

Any Clue what is causing this error.

Thanks
Mitta

I_Server_Whale · Post by **I_Server_Whale** » Mon Mar 20, 2006 6:02 pm

ORA-01465: invalid hex number
Cause: In an UPDATE statement following a SELECT FOR UPDATE, part of the ROWID contains invalid characters. ROWID must be expressed in the proper and expected format for ROWID and within quotes.
Action: Enter the ROWID just as it was returned in the SELECT FOR UPDATE.

Check if thats the cause.

Thanks,
Naveen.

srimitta · Post by **srimitta** » Mon Mar 20, 2006 8:21 pm

I got this in google search, here what i am trying to understand is wether is it DataSatge error or Database error.What is the actual cause of this error.

It would be great if some one help me to defferentiate and understand for better solution.

Thanks
Mitta

I_Server_Whale · Post by **I_Server_Whale** » Mon Mar 20, 2006 8:27 pm

It is a Database error. Not a DataStage error.

rasi · Post by **rasi** » Mon Mar 20, 2006 8:31 pm

Mitta

Definitely it is Oracle Error. Could you provide us the SQL you are using inside your job.

Thanks

srimitta · Post by **srimitta** » Mon Mar 20, 2006 9:12 pm

It's simply INSERT INTO auot generated plug-in query........

srimitta · Post by **srimitta** » Mon Mar 20, 2006 9:14 pm

More info.........

I have re-created table with new name..........even this didn't help me.

rasi · Post by **rasi** » Mon Mar 20, 2006 9:14 pm

Hi

Are you by any chance using rowid as your column name in your Oracle plug-in?

srimitta · Post by **srimitta** » Mon Mar 20, 2006 9:17 pm

No......I am sure..........I cheked it

rasi · Post by **rasi** » Mon Mar 20, 2006 9:24 pm

Srimitta

Have you tried inserting manually into the Oracle table using sql plus or any other tools

rasi · Post by **rasi** » Mon Mar 20, 2006 9:28 pm

Mitta

Are you using RAW as datatype for any of your columns?...

srimitta · Post by **srimitta** » Mon Mar 20, 2006 9:28 pm

.........That's what I have planned to do........firtst thing in the morning.........

srimitta · Post by **srimitta** » Mon Mar 20, 2006 9:37 pm

Rasi.........I didn't get you

RAW data type

srimitta · Post by **srimitta** » Mon Mar 20, 2006 9:41 pm

I remember one field is defined as VarBinary........does it make any difference........

rasi · Post by **rasi** » Mon Mar 20, 2006 9:45 pm

Mitta

Here is the list of Oracle In Built data types

Oracle Built-In Datatypes
A datatype associates a fixed set of properties with the values that can be used in a column of a table or in an argument of a procedure or function. These properties cause Oracle to treat values of one datatype differently from values of another datatype. For example, Oracle can add values of NUMBER datatype, but not values of RAW datatype.

Oracle supplies the following built-in datatypes:

Character datatypes
CHAR
NCHAR
VARCHAR2 and VARCHAR
NVARCHAR2
CLOB
NCLOB
LONG
NUMBER datatype
DATE datatype
Binary datatypes
BLOB
BFILE
RAW
LONG RAW

Another datatype, ROWID, is used for values in the ROWID pseudocolumn, which represents the unique address of each row in a table.

The RAW and LONG RAW datatypes are provided for backward compatibility with existing applications. For new applications, you should use the BLOB and BFILE datatypes for large amounts of binary data

Thanks