>>> RELATION_NAME
>>> =
>>> Statement failed, SQLSTATE = 22001
>>> arithmetic exception, numeric overflow, or string truncation
>>> -string right truncation
>>> -expected length 10, actual 21
>>> SQL>
>> Seems to be a problem with using the TYPE OF clause for the data type.
>> When I re
On 10/03/14 01:25, Thomas Steinmaurer wrote:
>> RELATION_NAME
>> =
>> Statement failed, SQLSTATE = 22001
>> arithmetic exception, numeric overflow, or string truncation
>> -string right truncation
>> -expected length 10, actual 21
>> SQL>
> Seems to be a problem with using the TYPE OF
Hello,
> I'm using the build mentioned in the subject, 32-bit, on Windows 7 64-bit.
>
> In a UTF8 database, I have a table with the following name:
>
> A_VERY_LONG_TABLENAME
>
>
> And a package with a single selectable SP, basically querying the table
> names:
>
> SET TERM ^^ ;
> CREATE OR ALTER P
Hello,
I'm using the build mentioned in the subject, 32-bit, on Windows 7 64-bit.
In a UTF8 database, I have a table with the following name:
A_VERY_LONG_TABLENAME
And a package with a single selectable SP, basically querying the table
names:
SET TERM ^^ ;
CREATE OR ALTER PACKAGE PKG_SCHEMA_