Page 1 of 1

bfile support

Posted: Tue 25 Apr 2006 14:45
by lclclc
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();

Posted: Wed 26 Apr 2006 07:49
by Paul
We reproduced your problem and fixed it. This fix will be included in the next OraDirect .NET build.