Re: pl/sql with Oracle 7

In article <2s3d8l$glh_at_master.di.fc.ul.pt>, roque_at_master.di.fc.ul.pt writes:
|> Hi,
|> I'm trying to use pl/sql with oracle ...
|> My basic ideia is to build a package so that I can call some
|> of the procedures from a client program..
|>
|> 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 .
|>

Yes, you can use sqlplus to load pl/sql packages and stored procedures. To diagnose errors, you can execute:

show errors

immediately after you do your load (don't exit out of sqlplus).

If you do exit out of sqlplus, you can show errors for any pl/sql object (packages, package bodies, procedures, functions) by executing

show errors <object type> <object name>

for example:

show errors package body foo

Will show you a list of parser errors with line numbers. Sometimes the line numbers are off. You can see the actual source that is referred to by selecting on user_source for the object name and type.

Hope this helps

-- 
Derek Fields
(derek_at_gamekeeper.bellcore.com)