Ora-01461 Error

[Joker]

I Use PL/developer to manage my oracle db,I found a interest question,I use sql "insert into sysuser(id,usercode,username,password) values(7,'Hello','中国','123')" ,it can insert a data row into my database , but i usr table-->edit data menu ,i fill the datagrid to new row,the data is 7,hello,中国,123.then i use post changes button ,but this programm tell a ora-01461 error,but I use this tool in another machince ,i run well .can you help me.

 

[Marco Kalter]

Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[Joker]

--- Info ---

PL/SQL Developer
Version 7.1.0.1337
0 - 0 user license
Windows 2003 Enterprise Edition 5.2 Build 3790 (Service Pack 1)

Physical memory : 1,308,968 kB (355,640 available)
Paging file : 3,128,300 kB (2,221,988 available)
Virtual memory : 2,097,024 kB (1,954,784 available)

Parameters
D:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
D:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
D:\Program Files\PLSQL Developer\Preferences\Administrator\default.ini

Plug-Ins

Aliases
EAST_240
WELLSYSTEM
zhyzypj

Homes
OraHome92 (D:\oracle\ora92)

DLLs
D:\oracle\ora92\bin\oci.dll

TNS File
D:\oracle\ora92\Network\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: D:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.1.0

Character Sets
Character size: 2 byte(s)
CharSetID: 852
NCharSetID: 2000
Unicode Support: True
NLS_LANG: SIMPLIFIED CHINESE_CHINA.ZHS16GBK
NLS_CHARACTERSET: ZHS16GBK
NLS_NCHAR_CHARACTERSET: AL16UTF16

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME = D:\oracle\ora92
ORACLE_HOME_NAME = OraHome92
API = D:\oracle\ora92\dbs
ORACLE_GROUP_NAME = Oracle - OraHome92
NLS_LANG = NA
OLEDB = D:\oracle\ora92\oledb\mesg
VOBHOME2.0 = D:\oracle\ora92
OO4O = D:\oracle\ora92\oo4o\mesg

SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 1
DEFAULT_HOME = OraHome92
LAST_HOME = 0

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = OraHome92
PATH = D:\oracle\ora92
NLS_LANG = NA

SOFTWARE\ORACLE\AUTOTUNE9.2.0
help_path = ${vobhome2.0}bin/
debug_flags =
startlog = ${home}autotune/%1.log
trace_report = 0
trace_data = 0
collect_int_in_min = 15
analyze_int_in_hrs = 24
max_errors_allowed = 5
wip_batch = 0
wip_window = 0
wip_logfile = 0
wip_logtable = 0

SOFTWARE\ORACLE\EXPERT9.2.0
home = ${vobhome2.0}sysman/expert
help_path = ${vobhome2.0}bin/
xpcoin = ${vobhome2.0}bin/xpcoin
default_rule_file = xpo000
debug_flags =
sample = ${home}sample/
sample_xdl = ${sample}xppso.xdl
startlog = ${vobhome2.0}sysman/temp/xpexpert.log
trace_report = 0
trace_data = 0
max_orphan_txn_reqs = 100
max_cache_txn_reqs = 50
extract_explain_plan = 0
create_tmp_plan_table = 0
tmp_plan_table = xp_tmp_plan
wip_batch = 0
wip_window = 1
wip_logfile = 0
wip_logtable = 0
quicktour_start = ${vobhome2.0}classes/oracle/sysman/qtour/tune/us/tune.htm
report_viewer = write
startup_wizard = 1
collect_trace_stats = 1
standalone_mode = 0

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle - OraHome92
ORACLE_HOME_NAME = OraHome92
ORACLE_HOME = D:\oracle\ora92
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
ORACLE_BUNDLE_NAME = Enterprise
ORAMTS_CP_TRACE_LEVEL = 0
ORAMTS_CP_TRACE_DIR = D:\oracle\ora92\oramts\Trace
ORAMTS_CONN_POOL_TIMEOUT = 120
ORAMTS_SESS_TXNTIMETOLIVE = 120
ORAMTS_NET_CACHE_MAXFREE = 5
ORAMTS_NET_CACHE_TIMEOUT = 120000
ORAMTS_OSCREDS_MATCH_LEVEL = OS_AUTH_LOGIN
ORACLE_HOME_KEY = Software\ORACLE\HOME0
SQLPATH = D:\oracle\ora92\dbs
MSHELP_TOOLS = D:\oracle\ora92\MSHELP

SOFTWARE\ORACLE\iSQLPlus
ServerCount = dword:00000000

SOFTWARE\ORACLE\ODP.NET
TraceFileName = C:\ODPNET.trc
TraceLevel = 0
TraceOption = 0

SOFTWARE\ORACLE\OLEDB
CacheType = Memory
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRSet = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0

SOFTWARE\ORACLE\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = D:\oracle\ora92\MSHELP\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = D:\oracle\ora92\oo4o

SOFTWARE\ORACLE\OracleMTSRecoveryService

SOFTWARE\ORACLE\OracleMTSRecoveryService\Protid_0
Name = HTTP
Host = ToadSoft
Port = 2030

SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup
NumberOfInstalls =

 

[Marco Kalter]

Can you upgrade to 7.1.5 and try again?

 

[Joker]

I am sorry.I have download 7.1.5,but it can't do well,it still shows me this error.when i use this tool to edit table data,input some chinese word .commit those data to database ,it cut some word and report ora-01461 error again.thank u very much.

 

[Marco Kalter]

Can you send me the Help > Support Info again from 7.1.5?

 

[Joker]

PL/SQL Developer
Version 7.1.5.1396
00.0 - 0 user license
Windows 2003 Enterprise Edition 5.2 Build 3790 (Service Pack 1)

Physical memory : 1,308,968 kB (446,868 available)
Paging file : 3,128,300 kB (2,296,992 available)
Virtual memory : 2,097,024 kB (1,945,812 available)

Parameters
C:\Program Files\plsql developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Program Files\plsql developer\Preferences\Default\Default.ini
C:\Program Files\plsql developer\Preferences\Administrator\default.ini

Plug-Ins

Aliases
EAST_240
WELLSYSTEM
zhyzypj

Homes
OraHome92 (D:\oracle\ora92)

DLLs
D:\oracle\ora92\bin\oci.dll

TNS File
D:\oracle\ora92\Network\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: D:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.1.0

Character Sets
Character size: 2 byte(s)
CharSetID: 852
NCharSetID: 2000
Unicode Support: True
NLS_LANG: SIMPLIFIED CHINESE_CHINA.ZHS16GBK
NLS_CHARACTERSET: ZHS16GBK
NLS_NCHAR_CHARACTERSET: AL16UTF16

 

[Joker]

Thank U evry much.