Profile

Cover photo
Roel Hartman
Worked at APEX Consulting
76 followers|122,459 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
76 people
Kellyn Pot'Vin-Gorman's profile photo
Brian Spendolini's profile photo
Anja Hildebrandt's profile photo
Patrick Barel's profile photo
Brendan Tierney's profile photo
Jeff Smith's profile photo
Ashish Sahay's profile photo
Михаил Даскалов's profile photo
Galo Balda'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
76 people
Kellyn Pot'Vin-Gorman's profile photo
Brian Spendolini's profile photo
Anja Hildebrandt's profile photo
Patrick Barel's profile photo
Brendan Tierney's profile photo
Jeff Smith's profile photo
Ashish Sahay's profile photo
Михаил Даскалов's profile photo
Galo Balda's profile photo
Basic Information
Gender
Male
Work
Employment
  • APEX Consulting
    Director