Oracle Datatype RAW(16) not fetching properly in ODBC Conn
Posted: Thu May 21, 2009 5:56 am
Hello,
I am working on Windows operating system and created a System DSN for connecting to remote Oracle SID. I was earlier using the same approach for MS SQL Server. I am using the following things:
1) Using odbc_connect to connect to database. (Using DSN in the case).
2) Using odbc_do function to perform the queries.
Now I have an Oracle statement where the data to be fetched contains a RAW data type in Oracle. I am filling the details in the associative array using the function odbc_fetch_array($result). But I am getting the junk value for the RAW datatype and else everything seems to be working fine.
When I use the same in MS SQL Server, the uniqueidentifier filed (parallel to RAW field in oracle) was fetched properly. Can you please let me know how I can use the same? I want the code to run both for MS SQL Server and Oracle.
Thanks a lot in advance
Mayank
I am working on Windows operating system and created a System DSN for connecting to remote Oracle SID. I was earlier using the same approach for MS SQL Server. I am using the following things:
1) Using odbc_connect to connect to database. (Using DSN in the case).
2) Using odbc_do function to perform the queries.
Now I have an Oracle statement where the data to be fetched contains a RAW data type in Oracle. I am filling the details in the associative array using the function odbc_fetch_array($result). But I am getting the junk value for the RAW datatype and else everything seems to be working fine.
When I use the same in MS SQL Server, the uniqueidentifier filed (parallel to RAW field in oracle) was fetched properly. Can you please let me know how I can use the same? I want the code to run both for MS SQL Server and Oracle.
Thanks a lot in advance
Mayank