Procedure in PL/SQL and Oracle Application Express

From: ing_ora <zana_f_at_hotmail.com>
Date: 23 Mar 2007 02:58:07 -0700
Message-ID: <1174643887.813248.167350@y80g2000hsf.googlegroups.com>

Hi All,

My question contains 2 Parts :

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

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.

I appreciate very much your help.

Thanks inadvance Received on Fri Mar 23 2007 - 04:58:07 CDT