Solved

Run a Query from within an Oracle Forms command button

Posted on 2004-09-09
4
204 Views
Last Modified: 2010-04-17
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
Comment
Question by:scapan
  • 2
4 Comments
 
LVL 22

Expert Comment

by:Helena Marková
ID: 12024037
There is HOST built-in there.
0
 
LVL 22

Accepted Solution

by:
Helena Marková earned 50 total points
ID: 12024104
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

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question