[cvsnt] Audit on Oracle

[AD]

Thank you David, a reserved name can be used if wrapped in quotes to create 
the table but
when I try to edit a file, CVSNT replays with an error ORA-01747: column not 
valid.

Making some test from SQL/Plus I have found that an insert into SessionLog 
is corrret if
the column Date is wrapped in quotes too.   See for example 
http://www.techonthenet.com/oracle/errors/ora01747.php


Now I am trying to re-install a different version of Oracle Client, if it 
don't resove the problem
I think to test MySql.

Thank you David for your support.

"David Somers" <dsomers at omz13.com> ha scritto nel messaggio
news:eonosj$a76$1 at paris.nodomain.org...
> AD wrote:
>
>> Oracle driver dosn't work on my server (I don't know why)  but the
>> problem
>> is not the driver, if I changed driver the problem is the same because in
>> Oracle database isn't possible use a field with the same name of  a type
>> (in Oracle I can use Date as a type of a field).
>
> I believe that other people use Oracle for the audit database, so it is
> possible to get it working :-)
>
> IIRC you can use a reserved name if it is wrapped in quotes.
>
>> I want use Oracle because my group have a good confidence with Oracle
>> database and Oracle tools as Forms and Reports.
>
> I wasn't questioning why you were using Oracle, just how.
>
> -- 
> David Somers - typographer/programmer/whatever
> Random (and sometimes useful) stuff blogged at http://www.omz13.com