Recent content by rpc

Dear Marco Kalter, I am from Czech Republic, where we using same characters like "ě

Yes, TOracleSession.BytesPerCharacter is bcAutoDetect. PL/SQL using same Oracle Home as DOA - It's same PC, same user profile, same database... Function MaxVarchar return 1333 characters, because CharacterSize (autodetected by GetBytesPerCharacter) is 3 and UseOCI80 is true. But 1333 isn't...

Sorry, DOA v 3.4.6.4 (for Delphi 7)

BTW: This problem is only when we use bind variables.

Yes, I know. I using DOA v 3.4.7 for Delphi.

Error result returned by DOA from Oracle: ORA-01480: trailing null missing from STR bind value TOracleSession.BytesPerCharacter = bcAutoDetect, code is UTF-8 & string length is more than 1333 characters.

When I run PL/SQL developer and execute same SQL containg varchar2 variable, the PL/SQL developer do SQL correctly. Same SQL executing with using D.O.A. it is incorrect. DOA return error from Oracle, that the string in variable isn't terminated by zero character.

Hi all, We have a problem with DOA. We have Oracle 9i database with many tables. Some tables have varchar(4000) columns & use there many characters like "ř