This is table info.
Code: Select all
SQL> desc tbl_clients;
SECRETKEY NOT NULL VARCHAR2(16)
HOSTNAME VARCHAR2(32)
STATUS VARCHAR2(3)
NOTE VARCHAR2(64)
IPADDR NOT NULL VARCHAR2(15)
Click this link to see Sreen Shot
1-1. Retrived data using Oracle Client
Correct.
1-2. Edit table using Oracle Client
Wrong result !!
2-1. Retrived data using Direct connection
Wrong result !!
2-2. Edit table using Direct connection
Wrong result !!
When I use direct connection(without Oracle Client), retrieved data is not shown correctly.
As I see...
If table field length is 4 and the data length is 4, OraDeveloper Studio eliminates last charactor.
When I use "Edit Table", always WRONG !! (Length & Nullable)
Oh... There is no registry key
"HKEY_LOCAL_MACHINE\SOFTWARE\CoreLab\OraDeveloper.
How to create it ? I want to know key name, type and value.