Print Thread
ORA-0186: literal does not match format stri
#27501 08/13/07 10:37 PM
Joined: Nov 2003
Posts: 50
Roanoke,VA USA
D
Member
OP Offline
Member
D
Joined: Nov 2003
Posts: 50
Roanoke,VA USA
I searched the formun and did not find an
existing post on this subject.

I have a good sized procedure with 20 parameters
and it returns a refcursor.

When I do a "test" on it using Version 7.1.1.1339
I get the error "ORA-0186: literal does not match
format string" in the message area at the bottom
of the form, with no guidance as to where to look.

I installed Version 7.0.3.1123 (MBCS) on
my client PC, and running the same "test file"
from it I get no error message and the test
does complete correctly.

I have copied the preferences folder from my
7.1.1.1339 folder to the 7.0.3.1123 (MBCS) instance.

Here are the detals on the Oracle I'm Using
Home: OraClient10g_home1
DLL: D:\oracle\product\10.2.0\client_1\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
Character size: 1 byte(s)

Re: ORA-0186: literal does not match format stri
#27502 08/13/07 11:04 PM
Joined: Nov 2003
Posts: 50
Roanoke,VA USA
D
Member
OP Offline
Member
D
Joined: Nov 2003
Posts: 50
Roanoke,VA USA
Please disregard.

I seem to have found my problem.

For Version 7.1.1.1339 I have an AfterConnect.sql file and it included an invalid default date format. It operationally caused no problem till I used this one procedure written by someone else.

I regret any inconvience that I may have caused.

Dave


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.031s Queries: 12 (0.009s) Memory: 2.5001 MB (Peak: 3.0423 MB) Data Comp: Off Server Time: 2024-05-14 17:49:42 UTC
Valid HTML 5 and Valid CSS