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