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 to [Release 6.1.0]
Information in this document applies to any platform.


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 =
10 STR = "7404-16-01"

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


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.