Re: [sqr-users] Odd SQR Behavior - Return code 256

["George Jansen" <GJANSEN@aflcio.org>]

Agreed with Bob Stone, almost certainly it is the client feeding a slightly 
wrong date string.

If you are simply providing the current date, then either

Sysdate

or, if you need just the day

Trunc(Sysdate)

will eliminate the nuisance of fooling around with To_Date NLS_DATE_FORMAT, and 
all that.

>>> "Schelske, Steve K." <SKSchelske@aaamichigan.com> 9/7/2007 3:12 PM >>>
We are running SQRs on a Windows server via Perl scripts against an
Oracle 10g RAC database on Linux.
 
I am coming across a very odd situation with various SQR programs.  Here
is what happens.
 
A program will run that has run successfully many times an it will fail
with the following error
 
(SQR 5528) ORACLE OCIStmtExecute error 1861 in cursor 7:
   ORA-01861: literal does not match format string 
 
In this case Cursor 7 is
 Cursor #7:
   SQL = Insert INTO PS_A_EARN_TOT_TBL      (ERNCD, A_EARNS_TOTAL,
         A_HRS_TOTAL, DESCR) Select AA.ERNCD, 0, 0, AA.DESCR From
         PS_EARNINGS_TBL AA Where AA.EFFDT    = (select MAX(AA1.EFFDT)
From
         PS_EARNINGS_TBL AA1 Where AA.ERNCD   = AA1.ERNCD And
AA1.EFFDT <=
         :1) 
 
where :1 is a string variable containing the current date
 
Then without making any changes to the program or data, the program is
restarted and runs successfully.
 
This seems to happen maybe 1 percent of the time and we have only seen
it happen in our production environment.
 
Does anyone have any ideas what could be causing this?

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users