| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: newbie: problem in dynamic SQL
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C08BB5.005598C8
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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_at_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
On top of the explanation, I have 2 questions.
Are you a dba ?
If not, does your dba knows that you will create
dynamically ?
=3D=3D=3D=3D=3D
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D INET: stephane_paquette_at_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_at_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). --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20 Author: Gabriel Galanternik INET: ggalanterni_at_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_at_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). ------_=_NextPart_001_01C08BB5.005598C8 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: newbie: problem in dynamic SQL</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>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?)</FONT></P> <P><FONT SIZE=3D2>Repeat until you believe it: THE DBA IS YOUR = FRIEND! THE DBA IS NOT MEAN! </FONT> </P> <P><FONT SIZE=3D2>HTH</FONT> <BR><FONT SIZE=3D2>Lisa</FONT> </P> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Gabriel Galanternik [<A = HREF=3D"mailto:ggalanterni_at_tesis-oys.com.ar">mailto:ggalanterni_at_tesis-oy= s.com.ar</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Wednesday, January 31, 2001 12:21 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: newbie: problem in dynamic SQL</FONT> </P> <BR> <P><FONT SIZE=3D2>stephane, just curious, really, no subtle = lines...</FONT> <BR><FONT SIZE=3D2>should I, a developer, tell my dba that I'm gonna = create temporary tables?</FONT> <BR><FONT SIZE=3D2>(I know most of you are dba's, please don't flame = me...)</FONT> <BR><FONT SIZE=3D2>deep inside I would say, yes, but, really = why?</FONT> <BR><FONT SIZE=3D2>Rigth access?</FONT> <BR><FONT SIZE=3D2>space allocation?</FONT> <BR><FONT SIZE=3D2>performance tunning?</FONT> <BR><FONT SIZE=3D2>curious dba?</FONT> </P> <P><FONT SIZE=3D2>FYI, I, as a technical support for my developers, I = would think twice before</FONT> <BR><FONT SIZE=3D2>creating tables dinamically.</FONT> <BR><FONT SIZE=3D2>and I would ask very good reasons to do it.</FONT> <BR><FONT SIZE=3D2>But when I had to do it I really didn't realize to = tell the dba...</FONT> </P> <P><FONT SIZE=3D2>Gabriel Galanternik</FONT> </P> <P><FONT SIZE=3D2>----- Original Message -----</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Sent: Wednesday, January 31, 2001 7:30 AM</FONT> </P> <BR> <P><FONT SIZE=3D2>On top of the explanation, I have 2 questions.</FONT> <BR><FONT SIZE=3D2>Are you a dba ?</FONT> <BR><FONT SIZE=3D2>If not, does your dba knows that you will = create</FONT> <BR><FONT SIZE=3D2>dynamically ?</FONT> </P> <P><FONT SIZE=3D2>--- Gabriel Galanternik = <ggalanterni_at_tesis-oys.com.ar></FONT> <BR><FONT SIZE=3D2>a =E9crit : > that's right and all code = referencing this</FONT> <BR><FONT SIZE=3D2>table</FONT> <BR><FONT SIZE=3D2>> must be dynamic too</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> my 0.02</FONT> <BR><FONT SIZE=3D2>> Gabriel Galanternik</FONT> <BR><FONT SIZE=3D2>> ----- Original Message -----</FONT> <BR><FONT SIZE=3D2>> To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>> Sent: Tuesday, January 30, 2001 7:35 AM</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Hi Anurag,</FONT> <BR><FONT SIZE=3D2>> Your table does not exist till the = time the</FONT> <BR><FONT SIZE=3D2>> procedure is actually</FONT> <BR><FONT SIZE=3D2>> executed. So, when your procedure tries = the access</FONT> <BR><FONT SIZE=3D2>> the table the compiler</FONT> <BR><FONT SIZE=3D2>> is going to complain cos it can't find the = table you</FONT> <BR><FONT SIZE=3D2>> are referring to.</FONT> <BR><FONT SIZE=3D2>> Since at compile time your table does not = exist.</FONT> <BR><FONT SIZE=3D2>> HTH</FONT> <BR><FONT SIZE=3D2>> Chandini</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> -----Original Message-----</FONT> <BR><FONT SIZE=3D2>> dewan</FONT> <BR><FONT SIZE=3D2>> Sent: 30 January 2001 09:36</FONT> <BR><FONT SIZE=3D2>> To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> hi,</FONT> <BR><FONT SIZE=3D2>> I am calling a stored procedure = which dynamically</FONT> <BR><FONT SIZE=3D2>> creates a table in a procedure. But if I = am</FONT> <BR><FONT SIZE=3D2>> accessing</FONT> <BR><FONT SIZE=3D2>> this table later in the procedure, ORACLE gives = an</FONT> <BR><FONT SIZE=3D2>> error PLS-00201-saying that identifier must = be</FONT> <BR><FONT SIZE=3D2>> declared(the identifier that it quotes is the = name</FONT> <BR><FONT SIZE=3D2>> of</FONT> <BR><FONT SIZE=3D2>> the table which was created dynamcally).</FONT> <BR><FONT SIZE=3D2>> please guide me</FONT> <BR><FONT SIZE=3D2>> anurag</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT = SIZE=3D2>____________________________________________________________</F= ONT> <BR><FONT SIZE=3D2>> Do You Yahoo!?</FONT> <BR><FONT SIZE=3D2>> Get your free @yahoo.co.uk address at</FONT> <BR><FONT SIZE=3D2>> <A HREF=3D"http://mail.yahoo.co.uk" = TARGET=3D"_blank">http://mail.yahoo.co.uk</A></FONT> <BR><FONT SIZE=3D2>> or your free @yahoo.ie address at</FONT> <BR><FONT SIZE=3D2>> <A HREF=3D"http://mail.yahoo.ie" = TARGET=3D"_blank">http://mail.yahoo.ie</A></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Please see the official ORACLE-L FAQ:</FONT> <BR><FONT SIZE=3D2>> <A HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Author: = =3D?iso-8859-1?q?anurag=3D20dewan?=3D</FONT> <BR><FONT SIZE=3D2>> INET: anu_dewan_at_yahoo.co.uk</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX:</FONT> <BR><FONT SIZE=3D2>> (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public = Internet</FONT> <BR><FONT SIZE=3D2>> access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an</FONT> <BR><FONT SIZE=3D2>> E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of</FONT> <BR><FONT SIZE=3D2>> 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB</FONT> <BR><FONT SIZE=3D2>> ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed</FONT> <BR><FONT SIZE=3D2>> from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information</FONT> <BR><FONT SIZE=3D2>> (like subscribing).</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Please see the official ORACLE-L FAQ:</FONT> <BR><FONT SIZE=3D2>> <A HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Author: Chandini Paterson</FONT> <BR><FONT SIZE=3D2>> INET: = chandini.paterson_at_morse.com</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX:</FONT> <BR><FONT SIZE=3D2>> (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public = Internet</FONT> <BR><FONT SIZE=3D2>> access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an</FONT> <BR><FONT SIZE=3D2>> E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of</FONT> <BR><FONT SIZE=3D2>> 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB</FONT> <BR><FONT SIZE=3D2>> ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed</FONT> <BR><FONT SIZE=3D2>> from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information</FONT> <BR><FONT SIZE=3D2>> (like subscribing).</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Please see the official ORACLE-L FAQ:</FONT> <BR><FONT SIZE=3D2>> <A HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Author: Gabriel Galanternik</FONT> <BR><FONT SIZE=3D2>> INET: = ggalanterni_at_tesis-oys.com.ar</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX:</FONT> <BR><FONT SIZE=3D2>> (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public = Internet</FONT> <BR><FONT SIZE=3D2>> access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an</FONT> <BR><FONT SIZE=3D2>> E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of</FONT> <BR><FONT SIZE=3D2>> 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB</FONT> <BR><FONT SIZE=3D2>> ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed</FONT> <BR><FONT SIZE=3D2>> from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information</FONT> <BR><FONT SIZE=3D2>> (like subscribing).</FONT> </P> <BR> <P><FONT SIZE=3D2>=3D=3D=3D=3D=3D</FONT> <BR><FONT SIZE=3D2>Stephane Paquette</FONT> <BR><FONT SIZE=3D2>DBA Oracle</FONT> <BR><FONT SIZE=3D2>stephane_paquette_at_yahoo.com</FONT> </P> <P><FONT = SIZE=3D2>__________________________________________________</FONT> <BR><FONT SIZE=3D2>Get personalized email addresses from Yahoo! Mail - = only $35</FONT> <BR><FONT SIZE=3D2>a year! <A = HREF=3D"http://personal.mail.yahoo.com/" = TARGET=3D"_blank">http://personal.mail.yahoo.com/</A></FONT> <BR><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Author: = =3D?iso-8859-1?q?paquette=3D20stephane?=3D</FONT> <BR><FONT SIZE=3D2> INET: stephane_paquette_at_yahoo.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information = (like subscribing).</FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Gabriel Galanternik</FONT> <BR><FONT SIZE=3D2> INET: ggalanterni_at_tesis-oys.com.ar</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>-----------------------------------------------------= ---------------</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =Received on Wed Jan 31 2001 - 12:38:27 CST
 |
 |