Dear Ximian,
 
I have a trouble also when selecting BLOB data type using ordinary Command:
 
    OracleCommand cmd =  db.GetTextCommand();
    //cmd.CommandText =  "SELECT * FROM UPLOADER";
    cmd.CommandText =  "SELECT TO_CHAR(UPLOAD_ID) AS UPLOAD_ID, "   //Number data type
                       "TO_CHAR(RECEIVE_DATE) AS RECEIVE_DATE, "    //Date data type
                       "PJK_CODE, "
                       "STATUS, "
                       "TO_CHAR(NO_OF_FILE) AS NO_OF_FILE, "        //Number data type;
                       "ORIGIN_FILE, "                              //BLOB data type
                       "FILE_NAME, "
                       "TO_CHAR(ID_REP) AS ID_REP, "                //Number data type
                       "FG_COPIED "
                       "FROM UPLOADER";
 
    //Response.Write("executing query: " + cmd.CommandText + "<br>");    
 
    OracleDataAdapter da = new OracleDataAdapter(cmd);             // ==> THERE IS NO RESPONSE WHEN MONO CLR EXECUTING... WHICH RUNNING WELL WITH .NET CLR!!!
 
And I still do not know how to handle this..
 
-Aguss
 
----- Original Message -----
Sent: Tuesday, August 03, 2004 9:50 AM
Subject: Runtime Mono OracleDataAdapter bug?

Dear all,
 
Finally I found a bug (?) in Runtime (CLR) Mono for class OracleDataAdapter, and its solusion:
 
OracleDataAdapter ONLY ACCEPT CHARACTER DATA TYPE OF RETURNING QUERY COMMAND!!!.
 
Please find the file I attached below.
 
Please ximian, fix it to make it complied with .NET CLR!
 
Best regards,
 
-Agus Surachman
PPATK - Indonesia
 
 
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.732 / Virus Database: 486 - Release Date: 7/30/2004
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.732 / Virus Database: 486 - Release Date: 7/31/2004

Reply via email to