CODEWITHSUNDEEP
oracle-databaseoracle-apex
JB999
JB999

Reputation: 507

Oracle Apex Interactive Grid ORA-01732

I'm having an issue while trying to update a table (on the front end) by using an Interactive Grid:

ORA-01732

Which is weird:

My code:

select distinct 

SECTION,
ITEM_ID,
PRODUCT_NAME,
QUANTITY,
DISCOUNT,  -- This is the column to be updated by the user
MY_PRIMARY_KEY

FROM MY_TABLE
WHERE USER = lower(v('APP_USER'))
AND MY_ID = :P31_MY_ID
AND DEAL  = :P31_MY_ITEM_DEAL

Does anyone know what might be happening here?

Thanks!

Upvotes: 0

Views: 591

Answers (1)

Koen Lostrie
Koen Lostrie

Reputation: 18630

The IG needs to be able to define each record with a unique identifier in order to successfully do execute the update statement. The keyword DISTINCT does not guarantee that. Try removing the DISTINCT from your query

Upvotes: 1

Related Questions