Re: sql plus error - usage message

> But why would anyone want to utilize the full extent & capability of their
> license? It's so much more fun and cost defective for an organization to
a)
> not becoime acquiainted with the tool they have purchased, b) not provide
> adequate training

I'd have to say this one is true.....
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?) 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........

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

"Hans Forbrich" <forbrich_at_yahoo.com> wrote in message news:3F7AF302.A7CED96F_at_yahoo.com...
> Daniel Morgan wrote:
>
> > Over the years I've seen a lot of people trying to kludge things
> > together using shell scripting, etc. and my
> > response is that it is the wrong tool for the job.
> >
> > Consider how easy what you are trying to do would be using DBMS_JOB.
> > Full error handling would be
> > a breeze as well as only needing to deal with a single language making
> > long-term maintenance easier. Consider
> > using your shell script to execute a stored procedure: Same thing. And
> > done properly it becomes prortable
> > between host shells and operating systems something code such as your
> > can never be.
> >
> > I know Korn and Perl are nice tools with great capabilities. But
> > updating records that could be better done
> > in SQL and/or PL/SQL is just not one of those things. (let the religious
> > war begin).
>
> <soapbox mode=on>
>
> But why would anyone want to utilize the full extent & capability of their
> license? It's so much more fun and cost defective for an organization to
a)
> not becoime acquiainted with the tool they have purchased, b) not provide
> adequate training and c) reinvent the wheel and perform onging related
> maintenance. After all, if one actually used the Oracle product to it's
> full scope organizations would not have [as much] reason to whine about
the
> cost of the licenses.
>
> </soapbox>
>
> If all you have is a hammer ....
>
>
Received on Wed Oct 01 2003 - 13:05:15 CDT