Re: Re: Re: Re: DBD::Oracle

</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>

Comment on Re: Re: Re: Re: DBD::Oracle - RAW datatypes

Replies are listed 'Best First'.
Re: Re: Re: Re: Re: DBD::Oracle - RAW datatypes by cjensen (Sexton) on Oct 20, 2001 at 03:41 UTC
Yes, ora_field is the column name.	[reply]
Re: Re: Re: Re: Re: Re: DBD::Oracle - RAW datatypes by Anonymous Monk on Oct 26, 2001 at 05:03 UTC
<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>	[reply]