Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Raw to number conversion ( Problem with Negative number)

VJ4Dec 10 2010 — edited Dec 14 2010
Hello,
I want to convert the raw datatype number to number datatype.

for ex:- I have number 40 then i want to convert it to raw or else from a raw value ( ex:- 33FFE is raw value for 40) then i should pass this value to a function and i should get a number value i,e 40. I am using a built in oracle package for the same. dbms_xdbutl_int.rawtonum() for the same it also does the conversion but the problem is with negative value. When i pass -40 ( negative 40) it gives a invalid answer.

*Please guide me with some proper method in which i can pass a raw value , either positive or negative to the function and then get a number in return , with proper sign ( +ve or -ve).*

thanks in advance !!!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2011
Added on Dec 10 2010
14 comments
6,543 views