Re: Procedure in PL/SQL and Oracle Application Express

ing_ora wrote:
> Hi All,
>
> My question contains 2 Parts :
>
> 1) the first part : how can I Create a procedure in PL/SQL that
> generate a text file for me baesed on a query of a table. For instance
> the content of this table
>
>
> ORDER_ID,CUSTOMER_ID,ORDER_TOTAL,ORDER_TIMESTAMP,USER_ID
> 1,1,1200,5-11-2006 13:17:45,2
> 2,2,599,31-10-2006 13:17:45,2
> 3,2,1999,26-10-2006 13:17:45,2

UTL_FILE http://www.psoug.org/reference/utl_file.html

> 2) the second Part : after I make this procedure, how Can I be able to
> excecute this procedure in Oracle Application Express , and as result
> of that excecution the generated file will be placed in a specific
> directory on my copmuter.

You can only write to the server to an address mappable from the server.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org