Setting string variables

[vpodolyaka]

Did anybody have a problem with Oracle 8.1.7 & DOA. When we make a query in which there are two and more string variables, we have the error: ORA-01460. If we use only one string variable along or with others type variable query works. If we use Oracle 8.1.6 we don't have this problem.
Does anyboby have a idea?

Best regards,
Vladimir.

 

[Marco Kalter]

Could it be that you also changed from a single byte character set to a multi byte character set when you moved from 8.1.6 to 8.1.7? In that case the TOracleSession.BytesPerCharacter property needs to be set to an appropriate value (e.g. bcAutoDetect).

If this is not the case, how are you using the 2 string variables in your query?

------------------
Marco Kalter
Allround Automations

 

[vpodolyaka]

Thank you, your solution has helped us.

best regards,
Vladimir Podolyaka