...the correct pronunciation is "lawwwwn GUY-lun"... > Ya, that's it! > (Peter still wanted to argue with me. Is Long Island the > "show-me" city?? But when he tried it, it worked) > > Thanks a bunch! > Barb > > > > ---------- > > From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] > > Reply To: [EMAIL PROTECTED] > > Sent: Thursday, October 31, 2002 12:13 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Raw / VB / ADODB > > > > Barb, > > > > Ask them to wrap RAWTOHEX() around the RAW column, which > > will convert the resulting datatype to VARCHAR2? > > > > Hope this helps... > > > > -Tim > > > > > Solaris 8 > > > Oracle 8.1.7.3 > > > > > > We have a field level_id defined as raw(5) in a table > > > called objects. I can pull data from this table from > > > sqlplus as follows: > > > select name, obj_id, level_id from objects where > > > level_id='0101010000' and name = '1X3HRJOHNSON' > > > > > > NAME OBJ_ID LEVEL_ID > > > --------------- ---------- ---------- > > > 1X3HRJOHNSON 500583 0101010000 > > > > > > The developer is not able to pull identifiable data > > > from the raw column level_id using VB. His notes are > > > shown below. We searched metalink and google, and > > > cannot find an answer. > > > Any help? Thanks!! > > > > > > Barb > > > > > > OK, > > > > > > I am using ADODB microsoft data objects version 2.7 > > > > > > I am using Oracle odbc driver 8.01 > > > I am trying to extract a raw field that is described > > > as level_id raw(5) > > > Every field extracts correctly except level_id.... > > > > > > > > > Here is an example code excerpt > > > > > > Set oRS = CreateObject("ADODB.Recordset") > > > sSQL = "Select distinct level_id from objects" > > > oRS.Source = sSQL > > > oRS.ActiveConnection = conn > > > oRS.Open > > > Do Until oRS.EOF > > > For i = 0 To oRS.Fields.Count - 1 > > > If oRS.Fields(i).Type = 204 Then ' RAW > > > field type > > > strTemp = oRS.Fields(i).Value > > > end if > > > next > > > oRS.movenext > > > loop > > > > > > In SQLPLUS when we ran a query on a record we got > > > level _id 0101010000 , the above vb program returned > > > 971. SQLPLUS level_id 010A030000, vb returned > > > 633... > > > > > > What is ODBC returning? is the value truncated > > > somehow? > > > does it need to be converted ? > > > I think we are getting partial data and not the > > > full length of the RAW field > > > Is RAW(5) equivalent to 10 bytes ? > > > SQLPLUS shows 10 positions on output .... > > > > > > HELP !!! > > > > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com -- > > > Author: Baker, Barbara > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- 858-538-5051 > > > http://www.fatcity.com San Diego, California -- > > > Mailing list and web hosting services > > > > > > > ---------------------------------------------------------- > > > ----------- To REMOVE yourself from this mailing list, > > > send an E-Mail message to: [EMAIL PROTECTED] (note > > > EXACT spelling of 'ListGuru') and in the message BODY, > > > include a line containing: UNSUB ORACLE-L (or the name > of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like > > > subscribing). > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 > > http://www.fatcity.com San Diego, California -- > > Mailing list and web hosting services > ---------------------------------------------------------- > > ----------- To REMOVE yourself from this mailing list, > > send an E-Mail message to: [EMAIL PROTECTED] (note > > EXACT spelling of 'ListGuru') and in the message BODY, > > include a line containing: UNSUB ORACLE-L (or the name > > of mailing list you want to be removed from). You may > also send the HELP command for other information (like > > subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com -- > Author: Baker, Barbara > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com San Diego, California -- > Mailing list and web hosting services > ---------------------------------------------------------- > ----------- To REMOVE yourself from this mailing list, > send an E-Mail message to: [EMAIL PROTECTED] (note > EXACT spelling of 'ListGuru') and in the message BODY, > include a line containing: UNSUB ORACLE-L (or the name of > mailing list you want to be removed from). You may also > send the HELP command for other information (like > subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).