bfile support

bfile support

Postby 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();
lclclc
 
Posts: 9
Joined: Tue 25 Apr 2006 14:36

Postby 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.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle