ORA-01460: unimplemented or unreasonable conversion requested with long strings
Posted: Wed 26 Oct 2005 13:02
Hi,
Our database is Oracle 9.2.0.4 installed on Sun Solaris. Database character set is UTF8.
The database is accessed from the Delphi 7 application using ODAC components 5.50.0.24 (Net option).
I have a stored procedure, which has many IN parameters of different types and one OUT parameter of type cursor. One of the IN parameters is of type VARCHAR.
I am using
TOraSession.Option.UseUnicode = True;
TOraSession.Option.Charset = UTF8;
Also I am setting parameters of stored procedure as:
TOraParam.DataType := dtWideString;
TOraParam.AsWideString := UTF8Encode(WideString);
When a regular English string with length less than 1333 char or Japanese string less than 445 char are passed to this parameter, it works properly; when I am trying a English string greater than 1333 or Japanese string greater then 445 is passed, I receive an Oracle exception: “ORA-01460: unimplemented or unreasonable conversion requested"
Our database is Oracle 9.2.0.4 installed on Sun Solaris. Database character set is UTF8.
The database is accessed from the Delphi 7 application using ODAC components 5.50.0.24 (Net option).
I have a stored procedure, which has many IN parameters of different types and one OUT parameter of type cursor. One of the IN parameters is of type VARCHAR.
I am using
TOraSession.Option.UseUnicode = True;
TOraSession.Option.Charset = UTF8;
Also I am setting parameters of stored procedure as:
TOraParam.DataType := dtWideString;
TOraParam.AsWideString := UTF8Encode(WideString);
When a regular English string with length less than 1333 char or Japanese string less than 445 char are passed to this parameter, it works properly; when I am trying a English string greater than 1333 or Japanese string greater then 445 is passed, I receive an Oracle exception: “ORA-01460: unimplemented or unreasonable conversion requested"