Strange SQL ?

From: Rexx <nebacar_nospam_at_eunet.yu>
Date: Wed, 23 Feb 2000 14:20:58 +0100
Message-ID: <890p99$kia$2@SOLAIR2.EUnet.yu>

Sorry for my bad english

I have two Oracle 7.3 DB domm and domb with the same table dom.zp_broj_racuna on both db. Column BROJ_RACUNA is the same NOT NULL VARCHAR2(11). But when I do select command behavior is different as is on listing:
How is it possible?

on DB domb:

SQLWKS> connect dom/dom_at_domb;
Connected.
SQLWKS> desc dom.zp_broj_racuna

Column Name                    Null?    Type


------------------------------ -------- ----


ZAPISNIK_SEQ                   NOT NULL NUMBER(8)
SIF_POSLOV                     NOT NULL NUMBER(2)
BROJ_RACUNA                    NOT NULL VARCHAR2(11)
IND_NOVI                       NOT NULL VARCHAR2(1)
UPLATA_DIN                              NUMBER(18,2)
STORNO_ID                               NUMBER(8)
P_DATE                                  DATE

SQLWKS> select * from dom.zp_broj_racuna where broj_racuna='9';

ZAPISNIK_S SIF_POSLOV BROJ_RACUNA I UPLATA_DIN STORNO_ID P_DATE
---------- ---------- ----------- - ---------- ---------- ---------

3 2 9 N 0 1 row selected.

SQLWKS> select * from dom.zp_broj_racuna where broj_racuna=9;

ZAPISNIK_S SIF_POSLOV BROJ_RACUNA I UPLATA_DIN STORNO_ID P_DATE
---------- ---------- ----------- - ---------- ---------- ---------
ORA-01722: invalid number <=======

?????????????????????????????????????????

on DB domm

SQLWKS> connect dom/dom_at_domm;

Connected.

SQLWKS> desc dom.zp_broj_racuna

Column Name                    Null?    Type


------------------------------ -------- ----


ZAPISNIK_SEQ                   NOT NULL NUMBER(8)
SIF_POSLOV                     NOT NULL NUMBER(2)
BROJ_RACUNA                    NOT NULL VARCHAR2(11)
IND_NOVI                       NOT NULL VARCHAR2(1)
UPLATA_DIN                              NUMBER(18,2)
STORNO_ID                               NUMBER(8)
P_DATE                                  DATE

SQLWKS> select * from dom.zp_broj_racuna where broj_racuna='9'; ZAPISNIK_S SIF_POSLOV BROJ_RACUNA I UPLATA_DIN STORNO_ID P_DATE
---------- ---------- ----------- - ---------- ---------- ---------

3 2 9 N 0 1 row selected.

SQLWKS> select * from dom.zp_broj_racuna where broj_racuna=9;

ZAPISNIK_S SIF_POSLOV BROJ_RACUNA I UPLATA_DIN STORNO_ID P_DATE
---------- ---------- ----------- - ---------- ---------- ---------

3 2 9 N 0 1 row selected. <==============

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Remove nospam from address

nebacar_at_eunet.yu

Received on Wed Feb 23 2000 - 07:20:58 CST