Re: Batch Sql vesrus Forms procedures
Date: 1995/05/29
Message-ID: <3qd1p4$sol$1_at_mhadf.production.compuserve.com>#1/1
The difference is whether or not you want you logic to be executed on the client vs. the server side of the overall system equation. PL/SQL within forms is a complete implementation of the PL/SQL language that executes within the running form. PL/SQL executed within SQL*Plus is given over to the server for execution.
This is a significant difference when architecting your overall system. By weighing the memory and network traffic capabilities of your installation, you may decide to have PL/SQL code executed centrally as stored procedures within the database. However if you are looking for local computation in your app, then client-side use of PL/SQL would certainly be appropriate.
hth,
JB Received on Mon May 29 1995 - 00:00:00 CEST