TimesTen PLSQL Procedure Taking A Character String As Parameter Has Problem With Comparison to TT_CHAR Type
(Doc ID 1605553.1)
Last updated on JUNE 05, 2019
Applies to:Oracle TimesTen In-Memory Database - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
User was trying to create a procedure that takes a character string type as an IN parameter. Inside the procedure its comparing the string to a column in a system table. Little known fact to user is that system table strings still use TT_CHAR(31) for data type. Inside the procedure if a comparison is done. In the example below the procedure returns the numerical column type in the table that matches the provided name, the table name in a system table is TT_CHAR(31):
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document