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();