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>
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
