RE: newbie: problem in dynamic SQL

[Mark Leith]

Title: RE: newbie: problem in dynamic SQL

LMAO! I love it! You trying saying that to me who has to battle you DBA types on a daily basis to earn a living..  Whoops.. off topic there.. Runs off in a flame retardant suit shouting sorry..

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, Lisa
Sent: Wednesday, January 31, 2001 06:37
To: Multiple recipients of list ORACLE-L
Subject: RE: newbie: problem in dynamic SQL

Gabriel, the dba needs to know about it, period, because he/she is responsible for storage and performance of the database overall.   In addition he or she may have other ideas that you can use instead of actually creating a table (pl/sql tables or something?)

Repeat until you believe it:  THE DBA IS YOUR FRIEND!  THE DBA IS NOT MEAN! 

HTH
Lisa

-----Original Message-----
From: Gabriel Galanternik [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 31, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: newbie: problem in dynamic SQL

stephane, just curious, really, no subtle lines...
should I, a developer, tell my dba that I'm gonna create temporary tables?
(I know most of you are dba's, please don't flame me...)
deep inside I would say, yes, but, really why?
Rigth access?
space allocation?
performance tunning?
curious dba?

FYI, I, as a technical support for my developers, I would think twice before
creating tables dinamically.
and I would ask very good reasons to do it.
But when I had to do it I really didn't realize to tell the dba...

Gabriel Galanternik

----- Original Message -----
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 31, 2001 7:30 AM

On top of the explanation, I have 2 questions.
Are you a dba ?
If not, does your dba knows that you will create
dynamically ?

--- Gabriel Galanternik <[EMAIL PROTECTED]>
a écrit : > that's right and all code referencing this
table
> must be dynamic too
>
> my 0.02
> Gabriel Galanternik
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L
> Sent: Tuesday, January 30, 2001 7:35 AM
>
>
> Hi Anurag,
>   Your table does not exist till the time the
> procedure is actually
> executed.  So, when your procedure tries the access
> the table the compiler
> is going to complain cos it can't find the table you
> are referring to.
> Since at compile time your table does not exist.
> HTH
> Chandini
>
> -----Original Message-----
> dewan
> Sent: 30 January 2001 09:36
> To: Multiple recipients of list ORACLE-L
>
>
> hi,
>   I am calling a stored procedure which dynamically
> creates a table in a procedure. But if I am
> accessing
> this table later in the procedure, ORACLE gives an
> error PLS-00201-saying that identifier must be
> declared(the identifier that it quotes is the name
> of
> the table which was created dynamcally).
> please guide me
> anurag
>
>
____________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> or your free @yahoo.ie address at
> http://mail.yahoo.ie
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?anurag=20dewan?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services    -- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California        -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Chandini Paterson
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services    -- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California        -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Gabriel Galanternik
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services    -- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California        -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).

=====
Stephane Paquette
DBA Oracle
[EMAIL PROTECTED]

__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gabriel Galanternik
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).