Re:pl/sql with Oracle 7
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