TD 6.0 with Oracle 11g

[demersj]

I just installed TD 6.0 with Oracle 11g and whenever I try to select from the database into a numeric variable, if the value returned from the database is a decimal, I get the message Error 104 "Attempt to fetch non numeric data into numeric column". My select is as simple as "Select 1/2 from dual into :nID" where nID is declared as a variable. Has anyone experienced this problem?

[Christof]

You probably need to set some session parameters for your local requirements. For selecting decimal values you need to configure the session with the local decimal and group separators being used.
For example, for Germany we call something like this once right after obtaining the first Sql Handle for a session:

Code: Select all

Call SqlPrepareAndExecute( hSql, "ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,'" )

Hth,
Christof

[demersj]

Great. It worked. Thanks a lot!