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 ;

Robert Martyn Accepted Answer Pending Moderation
  1. Tuesday, 7 April 2020 19:55 PM UTC
  2. SnapDevelop
  3. # 1

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.
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.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 24 December 2019 16:18 PM UTC
  2. SnapDevelop
  3. # 3

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.
  • Page :
  • 1


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