The first time you run a stored procedure, the data-source management system creates an execution plan for it and stores the plan in the database. The next time you run the stored procedure, it runs the precompiled procedure, assuming it is still cached in the database. This makes access to the database quicker and more efficient than when you access it with new queries each time.
The DataServer allows you to use ABL to run Oracle stored procedures. All pre-defined stored procedures initiated on behalf of the Oracle are executed from within ABL, using the RUN STORED-PROCEDURE statement. You define specific ABL language elements to the RUN STORED-PROCEDURE statement to match the profile or signature of your native stored procedure. You can also provide additional ABL statements subsequent to the RUN STORED-PROCEDURE statement to handle result sets from stored procedures.
