Re: PL/SQL output to desktop file via OWA

From: Eric Schlene <eschlene_at_purdue.edu>
Date: 1998/07/10
Message-ID: <35A63A4B.A32B3D5B@purdue.edu>#1/1

I've tried that and OWA doesn't create an HTTP header. I looked at the source code for owa_util.mime_header and it appears it wasn't supposed to generate the header itself. Any suggestions? -eric

Here's what I'm doing...

this stored procedure

CREATE OR REPLACE PROCEDURE almsnogv2
(title_in IN VARCHAR2,
zip_in IN address.zipcode%TYPE default NULL, school_in IN entity.pref_school_code%TYPE default NULL, order_in IN VARCHAR2,

 disp_in INTEGER)     AS
   v_cursor                INTEGER;
   v_status                INTEGER;
...a bunch of other variables...
   v_short_desc            tms_school.short_desc%TYPE;

BEGIN
--

if ( disp_in = 1 ) then

owa_util.mime_header( 'text/html' ); else

owa_util.mime_header( 'text/save-as' ); end if;
--
--

htp.title('Result Set');
owa_util.http_header_close;
--

now build select and retrieve records... v_cursor := DBMS_SQL.OPEN_CURSOR;
...

yields this HTML

<TITLE>Result Set</TITLE>

<BODY BGCOLOR="white" TEXT="black">
<BASEFONT SIZE="10">
<H1>My report</H1>
<HR>
<P>
<P>
<TABLE  BORDER="0" WIDTH="100%" CELLPADDING="5">
<TR ALIGN="LEFT" VALIGN="TOP">
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH="10%">0000462073</TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH="55%"><B><FONT SIZE=+1>Mr. Michael J.

Burke</TD>

<TD ALIGN="LEFT" VALIGN="TOP" WIDTH="30%"><FONT COLOR="red"></FONT></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH="5%" ></TD>
</TR>
<TR ALIGN="LEFT" VALIGN="TOP">
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH="10%"></TD>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH="55%" BGCOLOR="gold">3354 Boone Street<BR>West

Lafayette, IN 47906 (765) 497-1371</TD> <TD ALIGN="LEFT" VALIGN="TOP" WIDTH="30%">1993 Schools of Engineering</TD>

<TD ALIGN="LEFT" VALIGN="TOP" WIDTH="5%"></TD>
</TR>
</TABLE>
<P>

Received on Fri Jul 10 1998 - 00:00:00 CDT