SQL Language (MOSC)

MOSC Banner

NUMBERS pretending to be NULL in Oracle Cloud Database

in SQL Language (MOSC) 2 commentsAnswered

Our Delphi Application uses the 19.18.0.0.0 Oracle client to connect to a Oracle 19c Database in the Oracle Cloud.

Since a few months whenever it inserts some special numbers into number colums the field looks like NULL to all other applications.

Selected by the application itself the number appears to be correct.

The fun begins when you do something like this with Oracle SQL Developer or any other application:


-- Creating test table

CREATE TABLE TEST (

   TOOL NUMBER(1),

   COL1 NUMBER(15,2)

);



-- INSERTS performed by the application

INSERT INTO TEST (TOOL, COL1) VALUES (1, 196);

INSERT INTO TEST (TOOL, COL1) VALUES (1, 197);

INSERT INTO TEST (TOOL, COL1) VALUES (1, 198);

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