Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: Re: Re: DBD::Oracle - RAW datatypes

by cjensen (Sexton)
on Oct 19, 2001 at 21:02 UTC ( [id://120070]=note: print w/replies, xml ) Need Help??


in reply to Re: Re: DBD::Oracle - RAW datatypes
in thread DBD::Oracle - RAW datatypes

Oh, that's weird. You're getting exactly double the number of bytes. What does your table definition look like? Do you have more than one binary object in the table? Have you tried using bind_param_inout and specifying ora_field along with ora_type?

Replies are listed 'Best First'.
Re: Re: Re: Re: DBD::Oracle - RAW datatypes
by Anonymous Monk on Oct 20, 2001 at 02:52 UTC
    </head> <body> The table has 3 columns:

    VARCHAR2(20)
    NUMBER(10)
    RAW(2000)

    I inserted 6 rows, so there are 6 RAW's in the table when I do my select - 1 RAW per row...

    I haven't tried using bind_param_inout or ora_field. BTW - what exactly does ora_field refer to? The column name?...

    </body> </html>
      Yes, ora_field is the column name.
        <html> <head> <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1"> </head> <body> I tried using the ora_type, ora_field, bind_param_inout, etc. The data is still doubling...

        When inspecting the actual files that are returned in the result set, I noticed, in addition to the size doubling, that the format is being returned in hex, not binary. I know that RAW datatypes are stored as hex values, but have been assuming that Oracle would convert the hex back to binary on the way out. So, I tried using the HEXTORAW(raw_column_name) function in my select statement. My result set still gets returned as hex...

        Any other suggestions?...
        </body> </html>

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://120070]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (8)
As of 2024-03-28 10:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found