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

Last updated on MARCH 08, 2017

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

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 hundreds of Community platforms