Re: Any projects with lots of server-side PL/SQL?

From: Frank Carnovale <frankc_at_shell02.ozemail.com.au>
Date: 1995/09/17
Message-ID: <43hgsd$quj_at_oznet03.ozemail.com.au>#1/1


Subject: Any projects with lots of server-side PL/SQL? Newsgroups: comp.databases.oracle
Summary: Call for big PL/SQL reference sites Keywords: PL/SQL reference OLTP

This is a call for PL/SQL-committed reference sites, (ie. in the rdbms, not in tools) in return for which we are happy to compare notes.

We have completed a lot of performance and functionality testing all of which suggests that an excellent client-server implementation strategy is to implement practically all of the server-side logic in PL/SQL (version 2) packages. The emphasis here is on highvolume  OnLineTransactionProcessing (OLTP) apps. The purpose is to minimise net traffic, achive TP throughput rates, and at the same time present a more business-transaction-focused service to the developers of the front-end apps; ie. they now think in terms of TP calls rather than RDBMS navigation.

As suggested in the PL/SQL manual, the DBA can now even turn off all access privs from the tables and just allow execute privs on selected packages.

This of course puts a completely different light on the selection of the PC-side client tool; I can elaborate if anyone wants to nudge me on that one.

My questions are..

  • Are there any other sites which have come to the same conclusions about PL/SQL and are committing to it in a BIG way? We need names to prove to management that we are not doing trail-blazing R&D here.
  • Are there any pitfalls or regrets in implementing substantial parts of a project in PL/SQL?
  • Does anyone have any metrics on productivity of PL/SQL versus a 4GL?
  • Is there a swap-site somewhere (better than the stuff on Compuserve) where good user-written utility PL/SQL packages and relevant life stories are traded? If not, anyone want to start one?
  • Gupta SQLWindows supports the passing of Version 2 "PL/SQL tables" as IN and OUT parameters. Developer 2000, Powerbuilder, and Delphi allow scalar parameters only. Is there a VBX, a Delphi component, or a different 4GL which can match Gupta here? I can't believe it if no-one has written a VBX for this one yet, but watch this space if I get no replies.
  • Anyone know if the O'Reilly book on PL/SQL is out yet?

Thanks to any responders. Received on Sun Sep 17 1995 - 00:00:00 CEST

Original text of this message