• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

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!
0
scapan
Asked:
scapan
  • 2
1 Solution
 
Helena Markováprogrammer-analystCommented:
There is HOST built-in there.
0
 
Helena Marková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.
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now