Re: sql plus error - usage message

On Wed, 1 Oct 2003 13:05:15 -0500, "Pat" <miapjp_at_chartermi.net> wrote:

>I've not heard of DBMS_JOB, I'll have to research it and see if we have it
>installed (I'm assuming it's a utility?)

It is a procedure you get with all versions of Oracle. They are documented in the Oracle Supplied Procedures manual.
>And as for calling a stored procedure.....they're lovely except that to test
>anything means (I've been told) you need explicit rights (not roles) to all
>the object in the stored procedure and I've never been able to use one
>without having to go through days of figuring out permissions........
>

Nonsense. Usually the owner of the tables and the stored procedures are identical. No explicit permissions needed

>I'm modifying this code and as to why it's done this way....who knows? The
>analyst and I decided to put it into the C++ program that the script calls,
>that's where the other work on this table is being done.
>
>Thanks all!
>
>Pat

--
Sybrand Bakker, Senior Oracle DBA