Setting up Wallet Using Orapki - I have a stored procedure that is using utl_http to retrieve the contents of a web page. Basically I am doing web scraping for information. I have previou...
Planning for the Future
I did some investigation. There was a constant definining the maximum amount of records to be two. Why wasn't the system crashing? Wouldn't they be trying to access some memory or indexes that were out of bounds? Nope.
A close inspect of the code showed that it counts the number of records. Then it would retrieve the records, up to the maximum amount that it expected. The system just ignored all subsequent records. Nice. That's the way to design software. Plan for future expansion. And handle that expansion in a controlled way.