Members   Search      Help    Register    Login    Home
Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01460 when deleting a record
ORA-01460 when deleting a record [message #20893] Fri, 28 June 2002 00:29 Go to next message
Josef Vogler
Messages: 1
Registered: June 2002
Junior Member
I have a table PC_TAB containing a column ALLG_RECHNERNAME VARCHAR2(25).
Days ago I modified it to VARCHAR2(50).
I can insert and update this record, but I cannot execute the following statement:

delete from pc_tab where allg_rechnername = 'xKopie von xKopie von AATest'

when the content of the column is longer than 25 characters. (ORA-01460 unreasonable or unimplemented conversion). But I can update the column to a length less than 25 Chars and then execute the same delete statement. Oracle bug?

Report message to a moderator

Re: ORA-01460 when deleting a record [message #20894 is a reply to message #20893] Fri, 28 June 2002 02:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10509
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
i was not able to simulate your case.
can you furnish the following details
oracle version.
any OCI used (PRO*C ??)
or gateways? (microsoft,IBM?)

Report message to a moderator

Re: ORA-01460 when deleting a record [message #20897 is a reply to message #20894] Fri, 28 June 2002 04:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10509
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
are the oracle client and database, the same version?

try setting the
enviroment variable:
ORA_NLS** = $ORACLE_HOME/ocommon/nls/admin/data

If the database you are trying to connect to is built with a character set of
anything other than "US7ASCII" then then "ORA_NLS" environment variables must
be set.
Character set of a database can be checked by the SQL query:
select * from V$NLS_PARAMETERS;

Report message to a moderator

Re: ORA-01460 when deleting a record [message #20899 is a reply to message #20894] Fri, 28 June 2002 04:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10509
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
are the oracle client and database, the same version?

try setting the
enviroment variable:
ORA_NLS** = $ORACLE_HOME/ocommon/nls/admin/data

If the database you are trying to connect to is built with a character set of
anything other than "US7ASCII" then then "ORA_NLS" environment variables must
be set.
Character set of a database can be checked by the SQL query:
select * from V$NLS_PARAMETERS;

Report message to a moderator

Re: ORA-01460 when deleting a record [message #20903 is a reply to message #20893] Fri, 28 June 2002 04:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10509
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
are the oracle client and database, the same version?
try setting the
enviroment variable:
ORA_NLS** = $ORACLE_HOME/ocommon/nls/admin/data

If the database you are trying to connect to is built with a character set of
anything other than "US7ASCII" then then "ORA_NLS" environment variables must
be set.
Character set of a database can be checked by the SQL query:
select * from V$NLS_PARAMETERS;

Report message to a moderator

Re: ORA-01460 when deleting a record [message #20905 is a reply to message #20894] Fri, 28 June 2002 10:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10509
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I have no idea...im trying to simulate it...

Report message to a moderator

Re: ORA-01460 when deleting a record [message #21953 is a reply to message #20894] Thu, 12 September 2002 18:25 Go to previous messageGo to next message
Vamsi
Messages: 9
Registered: December 2001
Junior Member
Iam running into the same problem, any ideas ??
Scenario:

ORA-01460 when trying to insert data into the DB, the data in question is xml represented as string
Thank you

Report message to a moderator

Re: ORA-01460 when deleting a record [message #21965 is a reply to message #20894] Fri, 13 September 2002 04:44 Go to previous message
Mahesh Rajendran
Messages: 10509
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
what is the datatype?
oracle version?
OS?
pls paste the exact errno and message

Report message to a moderator

Previous Topic:DATABASE LINKS , ORA-02085
Next Topic:SELECT INTO statement doesn't want to work
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 04 01:49:30 CST 2012

Total time taken to generate the page: 0.31739 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.