Re: XSQL:insert-request

R.H. Nadorp wrote:

> Does anyone have any ideas how to get numeric values with decimals
> into a database-table using the XSQL-pages - framework.
>
> When processing a <xsql:insert-request I'm having problems inserting a
> numeric value with decimals (e.g. 101.23) into a table.
>
> Message: java.lang.NumberFormatException: 101.23
>
> I'm using the following xsl to transform the html-form into a
> <ROWSET><ROW> - format:
>
> <?xml version = '1.0'?>
> <rowset xsl:version="1.0"
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
> <xsl:for-each select="request/parameters">
> <row>
> <id><xsl:value-of select="id"/></id>
> <bkgdat><xsl:value-of select="bkgdat"/></bkgdat>
> <bkr_id><xsl:value-of select="bkr_id"/></bkr_id>
> <bedrag><xsl:value-of select="bedrag"/></bedrag>
> <dcin>
> <xsl:choose>
> <xsl:when test="dcin = 'C'">C</xsl:when>
> <xsl:otherwise>D</xsl:otherwise>
> </xsl:choose>
> </dcin>
> <omschrijving><xsl:value-of
> select="omschrijving"/></omschrijving>
> <rel_id> <xsl:value-of select="rel_id"/></rel_id>
> <rek_id> <xsl:value-of select="rek_id"/></rek_id>
> <afsnr> <xsl:value-of select="afsnr"/></afsnr>
> </row>
> </xsl:for-each>
> </rowset>
>
> The problem occurs on the "<bedrag>"-column.
>
>
> Greetings,
> R.H. Nadorp

Could it be you NLS_LANG settings expect a "," as numeric separator? Try to make the NLS_NUMERIC_CHARACTERS to be the same at both (client, server) sides, use an alter session statement to force/test this.

-- 

Regards,
Frank van Bortel