Profile

Cover photo
Roel Hartman
Worked at APEX Consulting
77 followers|132,066 views
AboutPostsPhotosVideos

Stream

Roel Hartman

commented on a post on Blogger.
Shared publicly  - 
 
Nice example.
But you can do it - even easier - without JSON....

Just pass in two arrays in your PL/SQL process (eg. as f10 and f11): one with Product ID and one with Available, and loop through them in your PL/SQL using the apex_application.g_f10 (and 11) arrays.
No need to pack and unpack JSON. 
However, if the number of items/columns you would like to pass through grows, JSON makes more and more sense ;-)
As a general rule APEX developers should stick to the built-in, declarative components in APEX to build applications. These are, after all, what make APEX developers so productive! But like most rules, this one has exceptions...
1
Dan McGhan's profile photo
 
Hi Roel,

Yes, for smaller stuff, arrays can work. But they are limited, not only by number but also by size (vc2 4000) and complexity (no nesting). I'd like to see people start thinking in terms of JSON as it's more flexible and that knowledge will prove more useful over time.
Add a comment...

Roel Hartman

commented on a post on Blogger.
Shared publicly  - 
 
Anton is just making fun of you... 
I will probably know more after today - but can't tell you if I do ;-)
1
Scott Wesley's profile photo
 
you know, reading that at the start of the week instead of the on a Friday - it sounds different ;-)
Add a comment...
Have him in circles
77 people
Anja Hildebrandt's profile photo
Niels de Bruijn's profile photo
Dick Dral's profile photo
Dietmar Aust's profile photo
Mohammed Al Hallaq's profile photo
Madicoye Djiba's profile photo
chet justice's profile photo
Brendan Tierney's profile photo
Benjamin Intsiful's profile photo

Roel Hartman

Shared publicly  - 
 
Developers with an Oracle Forms background might still remember this nice feature: If you click on a row in an Oracle Form "report" then it can be highlighted - either the full row or just a small first item of the row. The m...
1
Add a comment...

Roel Hartman

commented on a post on Blogger.
Shared publicly  - 
 
Patrick, Have you seen this site : http://www.oracle.com/technetwork/developer-tools/apex-listener/documentation/listener-dev-guide-1979546.html. I think it contains all the information you need. (Otherwise contact Kris Rice...)
1
Add a comment...
People
Have him in circles
77 people
Anja Hildebrandt's profile photo
Niels de Bruijn's profile photo
Dick Dral's profile photo
Dietmar Aust's profile photo
Mohammed Al Hallaq's profile photo
Madicoye Djiba's profile photo
chet justice's profile photo
Brendan Tierney's profile photo
Benjamin Intsiful's profile photo
Basic Information
Gender
Male
Work
Employment
  • APEX Consulting
    Director