Re: oracle output to excel

"amogh" <amogh.r_at_gmail.com> wrote in message news:C9EFf.8$eu3.110_at_news.oracle.com...
> Murtuja wrote:
>> I want daily report in Excel format.and this excel file should be
>> mailed to client.I want autoamtic process for that just like cron job.
>>
>> I am using Oracle 9i on Linux
>>
> The owa package has methods to dump data in a .xls format.
> You would have to make use of the htp packages to print
> the data for this.
>
> Rgds.
> Amogh

the owa package itself contains no such function or procedure

SQL> describe owa
FUNCTION GET_LINE RETURNS VARCHAR2

 IROWS                          NUMBER(38)              OUT

PROCEDURE GET_PAGE
 THEPAGE                        TABLE OF VARCHAR2(256)  OUT
 IROWS                          NUMBER(38)              IN/OUT

PROCEDURE GET_PAGE_CHARSET_CONVERT
 THEPAGE                        TABLE OF VARCHAR2(256)  OUT
 IROWS                          NUMBER(38)              IN/OUT
 CHARSET                        VARCHAR2                IN

PROCEDURE GET_PAGE_RAW
 THEPAGE                        TABLE OF RAW(256)       OUT
 IROWS                          NUMBER(38)              IN/OUT

FUNCTION INITIALIZE RETURNS NUMBER(38) PROCEDURE INIT_CGI_ENV

 PARAM_VAL                      TABLE OF VARCHAR2(32000) IN

PROCEDURE INIT_CGI_ENV
 NUM_PARAMS                     NUMBER                  IN
 PARAM_NAME                     TABLE OF VARCHAR2(32000) IN
 PARAM_VAL                      TABLE OF VARCHAR2(32000) IN

PROCEDURE SET_PASSWORD
 PWD                            VARCHAR2                IN

PROCEDURE SET_TRANSFER_MODE
 TMODE                          VARCHAR2                IN

PROCEDURE SET_USER_ID
 USR                            VARCHAR2                IN

and the htp package would only be used if output to a browswer via mod_plsql is required/configured

++ mcs Received on Mon Feb 06 2006 - 05:07:00 CST