Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to properly use Client_Text_IO.IS_OPEN

418686Mar 29 2006 — edited Apr 5 2006
I am generating a file from oracle forms and writing it out to the client machine. I am able to successfully create the file and close it. If on the offchance that a user tries to regenerate the file while it is open, the form hangs. Therefore, I want to check to see if it is open and if so display an error to the user and Raise Form_Trigger_Failure etc...

I am calling the webutil function like this:

IF Client_Text_IO.IS_OPEN(v_filename) THEN
error
Else
generate file
End if;

I have tried declaring v_filename as a Varchar2 and as a Client_Text_IO.File_Type to no avail. Is there a way I can check to ensure that the file is not open when the button to generate it is pressed?

Thanks,
c
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2006
Added on Mar 29 2006
14 comments
5,291 views