Re: calling sql script from pl/sql

Temporary tables are tables - funny I should need to mention it.

This is not an issue of profesionalism, I've never treated DBA's other then as professionals, it's a dificult profession, I'm aware of it. They've never treated me otherwise either.

The issue is of dogmatics. I have my own. I wonder if this is a particular DBA dogma. The question stays unanswered: why?

Regards,
Radu

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:5yfw8.90947$CH1.80375_at_sccrnsc02...
> I think the best approach is to work with them and state what you are
trying
> to accomplish - need to run this report, but the performance is not up to
> snuff. Then ask them how we could improve it. Ask them for their
expertise
> and input. You are then treating them as a professional, an expert in
their
> area and they will probably have a whole different attitude. Yes, Sybrand
> is correct. I can think of two ways - a view or a global temporary table.
> I suspect the problem lies in how the data is getting retrieved and some
> analysis would come up with a better solution.
> Jim
> "Radu Lascae" <r.nospam.lascae_at_wanadoo.nl> wrote in message
> news:fOew8.176$r7.11119_at_castor.casema.net...
> > With due respect: why?
> >
> > I'm not a DBA. I can think of several scenario's in BIS applications
where
> > I'd improve performance of certain repports by creating tables on the
fly.
> > Some of these reports can't even be created in straight SQL.
> >
> > Am I bound to outrage the DBA's with whom I'm working?
> >
> > Regards,
> > Radu
> > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> > news:uc21ba11ld1076_at_corp.supernews.com...
> > >
> > [...]
> > > Creating tables on the fly however must be considered very bad
practice.
> > >
> > > Regards
> > >
> > > --
> > > Sybrand Bakker
> > > Senior Oracle DBA
> > >
> > > to reply remove '-verwijderdit' from my e-mail address
> > >
> > >
> >
> >

>
> Received on Sat Apr 20 2002 - 11:00:47 CDT