bfile support

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
lclclc
Posts: 9
Joined: Tue 25 Apr 2006 14:36

bfile support

Post by lclclc » Tue 25 Apr 2006 14:45

I was using successfully the following code with version 2.5. The same code does not work any more with version 3.2 and 3.5, i.e. it returns null for DirectoryName and Filname. Is it a bug or a new behaviour?
Thanks :?:

sqlstmt="Select document_Text from document where document_id='0001'"; //document_text is a column of type bfile
localReader=OpenReader(sqlstmt);
if (localReader.HasRows)
{
localReader.Read();
try
{
bfile=localReader.GetOracleBFile(0);
if (!bfile.IsNull)
if (bfile.FileExists)
{
directoryName=bfile.DirectoryName;///now always null
fileName=bfile.FileName;//now always null
}
}
catch(Exception ex)
{
directoryName="";
fileName="";
}
}
localReader.Close();

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Wed 26 Apr 2006 07:49

We reproduced your problem and fixed it. This fix will be included in the next OraDirect .NET build.

Post Reply