Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Discoverer Language format problem.

1022513Aug 19 2013 — edited Feb 24 2020

Hi,

We have Discoverer BI downloaded on several pcs that got winxp installed. We upgraded these pcs to win7. however when we downloaded the discoverer, some win7 pc discoverer reports have expressed a format problem with Turkish characters. This never happened on winxp machines and not all win7 machines have this problem. Anybody got any idea how can to fix this?

Comments

odie_63

Hi,

Simple example :

If the count() function returns 11, then 11 div 10 = 1.1 (datatype xs:decimal), and 1.1 is not a valid value for the sequence iterator, it must be an integer.

At this point you have different options depending on how you want to round the value to an integer :

  • using fn:round()
  • using fn:floor()
  • using fn:ceiling()
  • casting to xs:integer directly : for $v in 1 to xs:integer(fn:count($anyType1/*:adad) div 10)

Your choice.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 7 2013
Added on Aug 19 2013
1 comment
1,657 views