Using APEX 19.1.0.00.15 -- DB: 18.0.0.0.0
In an interactive grid with 33 columns from Complex query (1 table & 1 complex view)
The table that will be update/inserted into has a table api which handles inserts and updates, based on the column value and an indicator column. (Originally generated from Oracle Designer)
I am trying to use the Automatic Row Processing(DML) with the Target Type = PL/SQL Code
I'll ask my question here and again at the end after all my example stuff:
Is there a limit on how much PL/SQL Code you can use here? Obviously there is a limit on how many characters based on the below info, but should there be?
I've used this method for a smaller table and all worked fine. But now with the larger table with
The problem causing the big red X is
So the rest of the code in the PL/SQL Code to Insert/Update/Delete is something like this (names have been changed to protect the innocent)
So again my question:
Is there a limit on how much PL/SQL Code you can use here? I could not find anywhere in the documentation that said this field was limited.
If this is the expected functionality I will just need to figure out a different way to perform this task.
Thanks,
Tillie