[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Decimal Object Conversion error

Subject: RE: [sqr-users] Decimal Object Conversion error
From: David Matsalla <David_Matsalla@Hyperion.com>
Date: Wed, 10 Dec 2003 09:46:05 -0800
List-help: <mailto:sqr-users-request@sqrug.org?subject=help>
List-id: This list is for discussion about the SQR database reporting language from Hyperion. <sqr-users.sqrug.org>
List-post: <mailto:sqr-users@sqrug.org>
List-subscribe: <http://www.sqrug.org/mailman/listinfo/sqr-users>,<mailto:sqr-users-request@sqrug.org?subject=subscribe>
List-unsubscribe: <http://www.sqrug.org/mailman/listinfo/sqr-users>,<mailto:sqr-users-request@sqrug.org?subject=unsubscribe>

You can find info on metalink about this regarding Oracle bug#2235818.
There is a Note that describes how to work around this problem, titled
"Mapinfo is able to access Oracle Spatial Data but on opening returns the
error: 
Unsupported data type for Column(s): {column name}"


David

-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org] On Behalf
Of Peter Burton
Sent: Wednesday, December 10, 2003 4:07 AM
To: 'sqr-users@sqrug.org'
Subject: RE: [sqr-users] Decimal Object Conversion error


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


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

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

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

Follow-Ups:
- [sqr-users] Re: Decimal Object Conversion error
  - From: Nathan Stratton Treadway <nathanst@ontko.com>

Prev by Date: [sqr-users] Put an end to this topic
Next by Date: [sqr-users] Help with wrapping..
Previous by thread: RE: [sqr-users] Decimal Object Conversion error
Next by thread: [sqr-users] Re: Decimal Object Conversion error
Indexes: [ Thread] [ Author] [ Date]
SQR-USERS List and Archive Info
SQRUG Home Page