Re: Populating 10G XE table with time AND date through VB.Net

From: Dave Baker <newsgroup_poster_at_jodael.com>
Date: Sun, 26 Mar 2006 09:08:23 +0800
Message-ID: <n8qb229q0spvfmao5qr6gh0h76frv1us06@4ax.com>

On Sat, 25 Mar 2006 08:18:12 +0000, Jim Smith <jim_at_jimsmith.demon.co.uk> wrote:

>>So, I try to change it in VB.Net with the following command from within
>>VB.Net:

>> alter session set NLS_TIMESTAMP_FORMAT = 'DD-MON-RR HH.MI.SS';

>Plain SQL statements in Oracle don't have trailing semi-colon. In
>SQL*Plus and compatible tools, the semi-colon is used to run the
>command. It is not required in the XE GUI, but is supported for
>compatibility with SQL*Plus.

Ok, testing....

>When submitting SQL statements directly to the database through odp.net
>or jdbc the semi-colon is not required, and in fact is an illegal
>character.

Ah, great - removing the trailing semicolon character in the string sent through VB.Net solves the "ORA-00911: invalid character" error.

Thanks very much.

Dave Received on Sat Mar 25 2006 - 19:08:23 CST