File_Type is a record, according to documentation you should now reference or change components of this. What are you trying to achieve by checking this? May be if you give your requirements more clearly, People will be able to help you. btw It has the following structure
TYPE file_type IS RECORD (
You can try referencing id of the file_type, like "IF param.id is not null" however I am sure there is a better way of what you are trying to do
Thank you very much. Using the "ID" field did the trick.
Could you please add details on "according to documentation you should...", because I did not just rush to forum, but I first searched the WEB quite a bit.
In the documentation I found:
The contents of
FILE_TYPEare private to the
UTL_FILEpackage. You should not reference or change components of this record.
But my quote was from there!
I probably need to get used to PLSQL more...
As has been mentioned Oracle states "you should not reference or change components of this [utl_file.file_type] record" the only supported way to check a variable of this type has been initialized (i.e. refers to an open file) is to use the utl_file.is_open function. Passing an uninitialized variable (i.e. one that does not refer to an open file either because it is null or because the file has been closed) will mean this function returns false; an initialized variable will mean it will return true.