Solved

Binary type in Sybase and Raw type in Oracle

Posted on 2004-10-06
5
787 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
ID: 12239962
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
ID: 12242678
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
ID: 12242929
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
ID: 12243496
1) Oracle Raw is equivalent to Sybase binary
vn
0
 

Author Comment

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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
To form a query 10 400
how to add a function to sybase 10 1,227
SYBASE Query combine date spans 7 674
Query plan fails to display when asked within a stored procedure 2 79
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
As a business owner, there are many things that keep you up at night. Profit margins, employee retention, human resource protocols, whether your product or service will remain competitive. When you own or manage a technology company that operates la…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

803 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