SQL Window Table Edit Limited to 1000 Chars

[PaulB]

Using the Table Edit in a SQL Window, I cannot enter text longer than 1000 chars into a VARCHAR2(4000) column. An error occurs:
ORA-01480: trailing null missing from STR bind value

Thanks, Paul

 

[Marco Kalter]

Perhaps you are using a 4-byte character set?

 

[PaulB]

PLSD is indeed using a 4-Char Set, but why I am not sure. The following from the Support Info Page:
PL/SQL Developer
Version 7.0.1.1066 (MBCS)
Using
Home: Ora10gR2
DLL: D:\Oracle\Ora10gR2\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Character size: 4 byte(s)
Registry
SOFTWARE\ORACLE\KEY_Ora10gR2
ORACLE_HOME = D:\Oracle\Ora10gR2
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

My database character set is AL32UTF8, which allows everything from 1 to 4 byte values and only uses the number of bytes required by each character.
Other client applications do not have a problem with this, so can you please explain why PLSD is using a 4-byte Set and how do I correct this?
Thanks, Paul

 

[Marco Kalter]

Can you modify the shortcut and add the BPC=1 parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" BPC=1

Let me know if this helps.

 

[johnsok]

Paul/Marco,

I opened a ticket on this very issue on 4/5/2004 (almost 2 years to the day from Paul's!). This has been an ongoing issue not just with this version of PLSD, but with every prior version as well. A real thorn because we have become so used to being able to use the PLSD interface to udpate data that when we have to use other (gasp) techniques, particularly on large chunks of data, we have to do 'extra' work because the other interfaces are not as nice as PLSD.

--Kate