My Oracle Support Banner

LogiView Functions sel_string and sel_value Interpret Certain Strings as Dates (Doc ID 1951462.1)

Last updated on JUNE 21, 2018

Applies to:

Oracle Agile Engineering Data Management - Version 6.1.1.0 to 6.1.3.0 [Release 6.1.0]
Information in this document applies to any platform.

Symptoms

On Oracle Agile e6.1.1 up to e6.1.3
Find that when a string is inserted into the application that has the format "####-##-##", LogiView cannot handle it as a string but handles it as a date
(for example in the Where-condition of LogiView function sel_value).
LogiView code example:
10 STR = "7404-16-01"
20 A_STR =
sel_string("T_MASTER_DAT.PART_NAME_GER","T_MASTER_DAT.PART_ID"=STR)
or:
10 STR = "7404-16-01"
20 A_NUM = sel_value("T_MASTER_DAT.C_ID","T_MASTER_DAT.PART_ID"=STR)

Error messages:
Runtime error: database returns error -995 in function "sel_string" !
or
Runtime error: database returns error -995 in function "sel_value" !



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.