Re: [sqr-users] String2Em: String to Decimal Object Conversion Error.

[Prasanth Pennepalli <pprasanth@yahoo.com>]

If you are on Oracle 9.2.0.7, try to upgrade the Oracle to the next patch 
level.  It worked for us.

----- Original Message ----
From: Peter Burton <Peter_Burton@hyperion.com>
To: This list is for discussion about the SQR database reportinglanguage from 
Hyperion Solutions. <sqr-users@sqrug.org>
Sent: Monday, July 31, 2006 9:42:47 AM
Subject: RE: [sqr-users] String2Em: String to Decimal Object Conversion Error.

All,

This event will not work in Oracle 10g.

You should upgrade your version of SQR to at least version 8.3.x
(Hyperion not Peoplesoft)

Peter

-----Original Message-----
From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org
[mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org] On Behalf
Of Jim McKeever
Sent: Monday, July 31, 2006 12:28 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] String2Em: String to Decimal Object Conversion
Error.

The following was offered as a solution several months ago and it worked
for us.  Of course, this applied to Oracle 9.2 so it may or may not take
care of 10g...
   
  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
  

"Knapp, Richard" <KnappR@umsystem.edu> wrote:
  
Ray,

If you refer to the column in your select as &employee_id, what happens?

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Rey Camoras
Sent: Monday, July 31, 2006 10:27 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] String2Em: String to Decimal Object Conversion
Error.

If I don't select an unscaled number column, the statement works fine.
Our best option might be to redefine all of our unscaled numbers in our
database.

-----Original Message-----
From: Knapp, Richard [mailto:KnappR@umsystem.edu] 
Sent: Friday, July 28, 2006 8:33 AM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] String2Em: String to Decimal Object Conversion
Error.


What happens if you leave the &empId out?

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Rey Camoras
Sent: Friday, July 28, 2006 10:14 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] String2Em: String to Decimal Object Conversion
Error.



This is an old issue revisited...

We're in the process of migrating our databases from Oracle 8 to 10G.
However, we're getting an error message in SQR when selecting a number
column that isn't scaled (defined as number, as opposed to number(10),
for example). We're using SQR version 6.0 on SunOS, release 5.8.


begin-program
begin-select
employee_id &empId

from emp
end-select
end-program

Error on line 3:
(SQR 6806) String2Em: String to Decimal Object Conversion Error.

SQR: Program Aborting.

However, if I add number such as 0 to the selected column, it works
fine, but it's not the ideal solution; we would have to change thousands
of sqr program to fix this issue.

begin-program
begin-select
0+employee_id &empId

from emp
end-select
end-program

I found this old sqr user group solution for Oracle 9i from 2003. Does
anyone know if this works for Oracle 10G? If not, does anyone know any
other fixes?

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

------------------------------------------------------------------------
------------------------------------------------
This transmission, together with any attachments, is intended only for
the use of those to whom it is addressed and may contain information
that is privileged, confidential, and exempt from disclosure under
applicable law. If you are not the intended recipient, you are hereby
notified that any distribution or copying of this transmission is
strictly prohibited. If you received this transmission in error, please
notify the original sender immediately and delete this message, along
with any attachments, from your computer.


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



------------------------------------------------------------------------
------------------------------------------------
This transmission, together with any attachments, is intended only for
the use of those to whom it is addressed and may contain information
that is privileged, confidential, and exempt from disclosure under
applicable law. If you are not the intended recipient, you are hereby
notified that any distribution or copying of this transmission is
strictly prohibited. If you received this transmission in error, please
notify the original sender immediately and delete this message, along
with any attachments, from your computer.


_______________________________________________
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



Jim McKeever 
Sr. PeopleSoft Analyst 

"When you were born, you were crying and everyone around you was
smiling.  Live your life so that when you die, you're the one who is
smiling and  everyone around you is crying."

         
---------------------------------
Yahoo! Music Unlimited - Access over 1 million songs.Try it free. 

_______________________________________________
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



_______________________________________________
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