Run a Query from within an Oracle Forms command button

I am new to Oracle forms and would like to be able to execute a query via an Oracle Forms command button that will generate a text file. My query works great in SQL Plus using the spool command followed by my select statement. Is there any way to use the spool and select statement from within Oracle Forms? Any suggestion will be appreciated. Thank you!
Who is Participating?
Helena MarkováConnect With a Mentor programmer-analystCommented:
If you execute a query in a block then you can use also TEXT_IO package. You can see description and examples in the on-line help.
Helena Markováprogrammer-analystCommented:
There is HOST built-in there.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.