Re:pl/sql with Oracle 7

From: Ken Levine <kenl_at_icebox.iceonline.com>
Date: Sat, 28 May 1994 06:30:19 GMT
Message-ID: <CqI1ww.2B0_at_iceonline.com>


> My problem is how to load pl/sql in Oracle ?????
> I've been trying to use sql*plus but the errors I find
> by "select * from USER_ERRORS", after compiling are
> meaningless .
> I'm a "rookie" with pl/sql, with sql in fact and I need to
> have a parser that can detect syntax errors and such...
You seem to have two problems here, but I'm not sure. 1) how to store pl/sql in the db. Using a package, the preferred way, use the Application Developer's Guide for Oracle7 - each package has a spec (referred to as the package itself, containing public variable, procedure, and function declarations), and a body(with code). Both are defined separately and loaded with create or replace package or create or replace package body syntax. You do need the manual.
2) A considerable aid is a product called SQL studio by Stanford Technology Group - gui client editor for procedures, functions, packages and triggers. It simplifies the work of editing Oracle7 procedural code and does a better job of pinpointing errors.

Note that you must have the procedural option to be able to do PL/SQL. Good luck!
Ken Levine
Vancouver, BC Received on Sat May 28 1994 - 08:30:19 CEST

Original text of this message