Binary type in Sybase and Raw type in Oracle

hello experts,
I am wondering if the use of these two types are the same in Sybase 12.x and Oracle 10g

Say sybase would work if we do
insert into aSybaseTable (binaryType) values(0x80abcd)

but if we do that in oracle for a raw type say
insert into anOracleTable(rawType) values(80abcd; (or replace  80abcd with 0x80abcd)
then oracle complains: incosistent data type: expected BINARY got NUMBER

I guess what I am looking for is
1) what is the equivalent type of Sybase binary type in Oracle?
And
2) How would we insert a value into Oracle raw field?

Thanks,
Do
dttaiAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
vn77Connect With a Mentor Commented:
1) Oracle Raw is equivalent to Sybase binary
vn
0
 
bretCommented:
Your question seems to be more about Oracle than Sybase ASE, so perhaps you should have asked your question in the Oracle group instead.

Just as a guess, perhaps Oracle wants the value in quotes?
0
 
dttaiAuthor Commented:
Dear Admin,
Could you please move my question to Oracle section as suggested by bret??
Thank you,
Do
0
 
grant300Connect With a Mentor Commented:
Try the Oracle function HEXTORAW.  It converts your hex value to a binary representation.

Bill
0
 
dttaiAuthor Commented:
I close this question, and move it to oracle
thanks everyone,
Do
0
All Courses

From novice to tech pro — start learning today.