1. Thomas Rolseth
  2. SnapDevelop
  3. Tuesday, 24 December 2019 15:29 PM UTC

I'm getting a parsing error when trying to port a datawindow to our Web API using the C# Model Generator.  The database is Oracle and the error is  Error: ORA-00952: missing GROUP keyword.  Below is the select statement being used.  It seems like the model generator does not like the Oracle LISTAGG function.  Is there a workaround or fix for this?  The datawindow previews fine in PB.

Thanks, Tom

 

SELECT x_partial.item_number as line_item,
(SELECT LISTAGG(rtrim(obs_code_id), '/') WITHIN GROUP (ORDER BY obs_code_id)
FROM l1_partial_codes WHERE partial_id = x_partial.partial_id) as hold
FROM
l1_claim_item,
x_partial
WHERE
l1_claim_item.claim_id = :claim_id AND
x_partial.partial_id = l1_claim_item.partial_id ;

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 24 December 2019 16:18 PM UTC
  2. SnapDevelop
  3. # 1

Hi Tom;

1) What version & build of PB / SnapObjects are you using?

2) Please open a Support Ticket for this issue.

Regards ... Chris

Comment
There are no comments made yet.
Thomas Rolseth Accepted Answer Pending Moderation
  1. Tuesday, 24 December 2019 17:52 PM UTC
  2. SnapDevelop
  3. # 2

Using PB/SnapDevelop 2019 build 2082 and submitted bug.

Thanks, Tom

Comment
There are no comments made yet.
Robert Martyn Accepted Answer Pending Moderation
  1. Tuesday, 7 April 2020 19:55 PM UTC
  2. SnapDevelop
  3. # 3

I have a similar issue.... I get the following.....  Error: ORA-00900: invalid SQL statement

Granted, the SQL statement is fairly long (415 lines) and includes several "with" statements and such.  But I really wouldn't consider it super complicated.... I mean, we have several over 2,000 lines long.

Comment
  1. Armeen Mazda @Appeon
  2. Tuesday, 7 April 2020 20:49 PM UTC
Please try with the new PowerBuilder 2019 R2, and if issue still persists please open support ticket.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.