Re: WebDB and report download to Excel

...when running with a debugger through the packages I found a solution:

function webdb.wwv_sys_sylk.print_rows tries to convert the retrieved values in number-values:

...
n := to_number(g_cvalue);
...

modified it to:

if substr(g_cvalue,1,1) = '0' then

   n := null;
else

   n := to_number......

Seems to work so far.

Klaus Zeuch <Klaus.Zeuch_at_erls04.siemens.de> schrieb in im Newsbeitrag: 8etu06$c9h$1_at_papyrus.erlm.siemens.de...
> Hi,
>
> when downloading files as sylk-file("Excel") webdb truncates leading
 zeroes
> in columns of database-type char/varchar2 if the contents can be
 interpreted
> as a number (doesn't do that in html/ascii-display). Any solutions (except
> prefixing the column retrieved in the sql-statement with select .... ' '
||
> column as .... from)?
>
> Version: 2.1.0.9.3 on 8.1.5.0.0 HP-UX 64 bit,
>
> Thanks
>
> Klaus
>
>
Received on Wed May 10 2000 - 00:00:00 CEST