Solved

Binary type in Sybase and Raw type in Oracle

Posted on 2004-10-06
5
772 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:dttai
5 Comments
 
LVL 10

Expert Comment

by:bret
Comment Utility
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
 

Author Comment

by:dttai
Comment Utility
Dear Admin,
Could you please move my question to Oracle section as suggested by bret??
Thank you,
Do
0
 
LVL 19

Assisted Solution

by:grant300
grant300 earned 150 total points
Comment Utility
Try the Oracle function HEXTORAW.  It converts your hex value to a binary representation.

Bill
0
 
LVL 2

Accepted Solution

by:
vn77 earned 350 total points
Comment Utility
1) Oracle Raw is equivalent to Sybase binary
vn
0
 

Author Comment

by:dttai
Comment Utility
I close this question, and move it to oracle
thanks everyone,
Do
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
A procedure for exporting installed hotfix details of remote computers using powershell
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now