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

From: Scott <Scott.Mattes_at_gmail.com>
Date: 27 Feb 2006 07:36:32 -0800
Message-ID: <1141054592.352929.165650_at_p10g2000cwp.googlegroups.com>


[Quoted] 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. Received on Mon Feb 27 2006 - 16:36:32 CET

Original text of this message