Precompilers and OCI (MOSC)

MOSC Banner

SQLDA->L wrong size on Oracle 12 Enterprise Edition

edited Mar 23, 2015 10:00AM in Precompilers and OCI (MOSC) 1 commentAnswered

Hi,

recently we run our programm on a 12.1.0.2.0 databases. We connect to the database with the Dynamic SQL Method 4 with proC.

On this database version we have a problem with the following statement:

number5 is a column with the type number(5); This column is set fix with 1.

SELECT number5

FROM tab1

WHERE number5=1

group by number5;

On all other databases the L variable has a value of 1280 (5 in highbyte = number(5) ), but in this case we get 129 in SQLDA->L[0]

When changing the statement in a way that more values are possible we get 1280 in SQLDA->L[0]

SELECT number5

FROM tab1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center