My Oracle Support Banner

Getting Error ORA-01858 When Use Siebel eScript to Query With TO_DATE Function On A Date Column In Siebel Application (Doc ID 2876072.1)

Last updated on JUNE 14, 2022

Applies to:

Siebel Tools - Version 21.12 and later
Information in this document applies to any platform.


After upgrade from Siebel IP16 to 21.12, getting Error ORA-01858 when use Siebel eScript to query with TO_DATE function on a Date Column in Siebel Application.   ADODB connection is used and call ADODB methods to retrieve records.


"ORA-01858: a non-numeric character was found where a numeric was expected"

The issue can be reproduced at will with the following steps:
1. Log into Siebel WebTools

2. Open/Create a workspace

3. Create a new Business Service with codes to retrieve a record set. Here is the code snippet

4. Log into Siebel client application

5. Navigate Administrator Business Service > Simulator to Simulate the Business Service


Upgraded from Siebel IP16 to Siebel 21.12.


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

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