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

["Bob Stone" <bstone@fastenal.com>]

Whenever I'm using a date that has to go to the Database I put a
TO_DATE($my_var, 'formatstring') around the insert, and use the same
format string for selecting from and inserting to.

I know that we have 1 file load originating on Sculptor systems where
instead of getting a date in the format '07-Sep-07' we get ' 7-Sep-07' -
and Oracle and SQR don't like to assume things on date formats.  We had
to tell it that spaces were 0s, and then still edit mask on the insert.

I'm not positive that all of that was necessary, but that's usually what
it means for me when I get the ORA-01861.

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Schelske, Steve K.
Sent: Friday, September 07, 2007 2:12 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Odd SQR Behavior - Return code 256

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