[sqr-users] Re: Error after Oracle update

[Nathan Stratton Treadway <nathanst@ontko.com>]

On Thu, Oct 21, 2004 at 04:20:35PM -0400, Fred Schiff wrote:
> Could I depend on you to tell me what Peoplesoft's solution is?
[...]
> From: amy.harvel@phoenix.gov [mailto:amy.harvel@phoenix.gov]
> Sent: Friday, October 17, 2003 8:54 AM
> To: sqr-users@sqrug.org
> Subject: Re: [sqr-users] (SQR 6806) String2Em: String to Decimal Object
> Conversion Error.
> 
> 
> Funny -- we had the same error yesterday -- there is a work around -- DONT
> change any SQR's.
> 
> Find Solution id 200744351 on PeopleSoft's web.
> 

I can't give you more information on that particular PeopleSoft
Solution, but this message I posted last year:
  http://www.sqrug.org/sqr-users/sqrusers_03q4/msg00549.html
goes into a bit of detail about the cause of this problem and the
various workarounds.  Note that the links I have there point into
Oracle's support database, so so see the documents I mention you'll need
to work with someone who has an MetaLink account (e.g. your DBA).




> From: GURON Rawender [mailto:rawender_Guron@rta.nsw.gov.au]
> Sent: Wednesday, September 17, 2003 2:52 AM
> To: 'sqr-users@sqrug.org'
> Subject: [sqr-users] '(SQR 6806) String2Em: String to Decimal Object
> Conversion Error' on Oracle 9.2.0.3
[...]
> I know there are workarounds, but they involve changing the code and we are
> looking for some elegant solutiuon. We have hundreds of programs, therefore
> changing the code to fix the problem is out of question.

The long-term solution is upgrading to a SQR v8.2 or later.  (For
example, the Oracle documents I link to specifically say that the "event
10499" fix is NOT available in Oracle 10, though I have not tested that
myself.) 

For short-term fixes, you have the option to set this event at the
"system" or the "session" levels in addition to code changes.  (Note
that setting the event at the "system" level might possibily affect
other database client software that has been modified to work correctly
with post-9.2.0.3 versions of Oracle, while setting it at the session
level will probably involve adding a few lines at the top of each SQR
program unless you already call a common "setup" routine in an include
file in all your programs.)

                                                        Nathan


----------------------------------------------------------------------------
Nathan Stratton Treadway  -  nathanst@ontko.com  -  Mid-Atlantic region
Ray Ontko & Co.  -  Software consulting services  -   http://www.ontko.com/
 GPG Key: http://www.ontko.com/~nathanst/gpg_key.txt   ID: 1023D/ECFB6239
 Key fingerprint = 6AD8 485E 20B9 5C71 231C  0C32 15F3 ADCD ECFB 6239

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