RE: [sqr-users] Decimal Object Conversion error

[Peter Burton <Peter_Burton@Hyperion.com>]

Vishnu,

It directs the Oracle database server to use the previous method (prior to
9.2.0.3) when dealing with NUMERIC (or DECIMAL) numbers.

Peter

> -----Original Message-----
> From: sqr-users-admin@sqrug.org@HYPERION  On Behalf Of
> <vishnu.murthy@wipro.com>
> Sent: Wednesday, December 10, 2003 6:59 AM
> To:   sqr-users@sqrug.org
> Subject:      RE: [sqr-users] Decimal Object Conversion error
> 
> 
> Hi,
> Yes it works fine, I want to know how it solves the problem,
> 
> how
> alter system set event='10499 trace name context forever,level 1'
> COMMENT='return 0 for the scale if NUMBER created without specifying the
> scale'
> SCOPE=SPFILE
> will solves this problem.
> like to know How the above commands corrects the problem.
> 
> Vishnu
> 
> 
> 
> 
> -----Original Message-----
> From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
> Behalf Of Ray Ontko
> Sent: Wednesday, December 10, 2003 5:10 PM
> To: sqr-users@sqrug.org
> Subject: Re: [sqr-users] Decimal Object Conversion error
> 
> 
> Vishnu,
> 
> Yes, it worked for Jon.  Is it not working for you?
> 
> Ray
> 
> On Wed, Dec 10, 2003 at 04:22:15PM +0530, vishnu.murthy@wipro.com wrote:
> >
> > Hi Jon,
> > I want to know this Decimal Object conversion error will be solved with
> you the command
> >
> > Have a DBA issue the following command:
> >
> >    alter system set event='10499 trace name context forever,level 1'
> >    COMMENT='return 0 for the scale if NUMBER created without specifying
> the scale'
> >    SCOPE=SPFILE
> >
> > would like to know how this problem will be solved when we run the above
> command.
> >
> > Vishnu
> >
> >
> > -----Original Message-----
> > From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
> > Behalf Of Jon Alsager
> > Sent: Tuesday, December 09, 2003 9:38 PM
> > To: sqr-users@sqrug.org
> > Subject: RE: [sqr-users] Decimal Object Conversion error
> >
> >
> > We had a similar problem a while back, and Mr. Burton offered the
> > following, which worked for us:
> >
> >    Have a DBA issue the following command:
> >
> >    alter system set event='10499 trace name context forever,level 1'
> >    COMMENT='return 0 for the scale if NUMBER created without specifying
> > the
> >    scale'
> >    SCOPE=SPFILE
> >
> > Jon
> >
> > -----Original Message-----
> > From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org] On
> > Behalf Of vishnu.murthy@wipro.com
> > Sent: Tuesday, December 09, 2003 8:07 AM
> > To: sqr-users@sqrug.org
> > Subject: [sqr-users] Decimal Object Conversion error
> >
> >
> > Hi
> > When I run report of SQR 6.2 with Oracle 9i getting the following error
> > Error on line 61: (SQR 6806) String2Em: String to Decimal Object
> > Conversion Error. SQR: Program Aborting. - Runtime error: exit code = 0
> > (SQR 6464) A function called from the shared library specified in the
> > grafcap file could not be found. SQRP: Program Aborting.
> > but the same report is working fine with Oracle 8.1.7.4.
> > I would like to know is there is problems in using SQR 6.2 with Oracle9i
> > Vishnu
> >
> >
> > Confidentiality Notice
> >
> > The information contained in this electronic message and any attachments
> > to this message are intended
> > for the exclusive use of the addressee(s) and may contain confidential
> > or privileged information. If
> > you are not the intended recipient, please notify the sender at Wipro or
> > Mailadmin@wipro.com immediately
> > and destroy all copies of this message and any attachments.
> >
> > _______________________________________________
> > 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
> >
> > Confidentiality Notice
> >
> > The information contained in this electronic message and any attachments
> to this message are intended
> > for the exclusive use of the addressee(s) and may contain confidential
> or privileged information. If
> > you are not the intended recipient, please notify the sender at Wipro or
> Mailadmin@wipro.com immediately
> > and destroy all copies of this message and any attachments.
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> ----------------------------------------------------------------------
> Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
> Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> Confidentiality Notice
> 
> The information contained in this electronic message and any attachments
> to this message are intended
> for the exclusive use of the addressee(s) and may contain confidential or
> privileged information. If
> you are not the intended recipient, please notify the sender at Wipro or
> Mailadmin@wipro.com immediately
> and destroy all copies of this message and any attachments.
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 


************************************************************************

If you have received this e-mail in error, please delete it and notify the 
sender as soon as possible. The contents of this e-mail may be confidential and 
the unauthorized use, copying, or dissemination of it and any attachments to 
it, is prohibited. 

Internet communications are not secure and Hyperion does not, therefore, accept 
legal responsibility for the contents of this message nor for any damage caused 
by viruses.  The views expressed here do not necessarily represent those of 
Hyperion.

For more information about Hyperion, please visit our Web site at 
www.hyperion.com
Here was a non admissible message part of 'application/ms-tnef' MIME
type. It has been automatically discarded before sending the message to
the list.