Re: How to run SQL Script from forms 6i?

Scott wrote:

put a button on the form, this is what the user will click

in the button click event:
- define a cursor for your select
- open the cursor
- open the output file
- loop over fetch, utl_file
- close the cursor
- close the output file

Note: util_file puts the output on the server, if you need the output
on the user's machine use the text_io built-in package.



utl_file emits from the database server; it puts the output into the file system available to the database server.

text_io emits from the Forms execution engine; it puts the output into the file system available to the application server.

Neither one outputs a file to the user's local PC disk (unless things have changed radically since my Forms 4.5 days).

Martin
.