From mark@cool-tools.co.uk Wed, 31 Jan 2001 12:28:37 -0800 From: "Mark Leith" Date: Wed, 31 Jan 2001 12:28:37 -0800 Subject: RE: newbie: problem in dynamic SQL Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Koivu, LisaSent: Wednesday, January 31, 2001 06:37To: Multiple recipients of list ORACLE-LSubject: 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:ggalanterni@tesis-oys.com.ar] 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 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: anu_dewan@yahoo.co.uk > > 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: ListGuru@fatcity.com (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: chandini.paterson@morse.com > > 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: ListGuru@fatcity.com (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: ggalanterni@tesis-oys.com.ar > > 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: ListGuru@fatcity.com (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 stephane_paquette@yahoo.com __________________________________________________ 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: stephane_paquette@yahoo.com 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: ListGuru@fatcity.com (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: ggalanterni@tesis-oys.com.ar 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: ListGuru@fatcity.com (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).