Skip to Main Content
Forums

SQL Developer

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.

Problem with update with function in Sql Developer 18.4

3623736Feb 13 2019 — edited Feb 14 2019

Hi,

I try to use inline plsql function in update in 18.4 and i found problem.

When i write ';' at the end of statement i get ORA-00933 sql error. Without ';' update goes well.

In others developers tools toad for example, update works ok with or without ';'

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

Post Details

Added on Feb 13 2019
#sql-developer
5 comments
166 views