RE: newbie: problem in dynamic SQL

that
was funny

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Koivu, LisaSent:   Wednesday, January 31, 2001 1:37 PMTo: 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 [<A
  href="mailto:ggalanterni_at_tesis-oys.com.ar">mailto:ggalanterni_at_tesis-oys.com.ar]   Sent: Wednesday, January 31, 2001 12:21 PM <FONT   size=2>To: Multiple recipients of list ORACLE-L <FONT   size=2>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? <FONT   size=2>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. <FONT   size=2>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 <ggalanterni_at_tesis-oys.com.ar> a écrit : > that's right and all code referencing this <FONT size=2>table > must be dynamic too <FONT size=2>> > my 0.02 > Gabriel Galanternik > ----- Original Message
• > To: Multiple recipients of list ORACLE-L > Sent: Tuesday, January 30, 2001 7:35 AM > > <FONT size=2>> 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. <FONT size=2>> Since at compile time your table does not exist. <FONT size=2>> HTH > Chandini <FONT size=2>> > -----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 <FONT size=2>> the table which was created dynamcally). <FONT size=2>> please guide me > anurag
  > > <FONT
  size=2>____________________________________________________________
  > Do You Yahoo!? > Get your
  free @yahoo.co.uk address at > <A target=_blank href="http://mail.yahoo.co.uk">http://mail.yahoo.co.uk <FONT size=2>> or your free @yahoo.ie address at > <A target=_blank href="http://mail.yahoo.ie">http://mail.yahoo.ie
  > -- > Please see the official
  ORACLE-L FAQ: > <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com <FONT size=2>> -- > Author: =?iso-8859-1?q?anurag=20dewan?= >   INET: anu_dewan_at_yahoo.co.uk > <FONT size=2>> Fat City Network Services    -- (858) 538-5051  FAX: > (858) 538-5051
  > San Diego,
  California        -- Public Internet
  > access / Mailing Lists <FONT
  size=2>> <FONT size=2>--------------------------------------------------------------------
  > 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 <FONT size=2>> (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:
    > <A target=_blank
    href="http://www.orafaq.com">http://www.orafaq.com <FONT size=2>> -- > Author: Chandini Paterson >   INET: chandini.paterson_at_morse.com
    > > Fat City Network
    Services    -- (858) 538-5051  FAX: <FONT size=2>> (858) 538-5051 > San Diego, California        -- Public Internet
    > access / Mailing Lists <FONT
    size=2>> <FONT size=2>--------------------------------------------------------------------
    > 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 <FONT size=2>> (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:
    > <A target=_blank
    href="http://www.orafaq.com">http://www.orafaq.com <FONT size=2>> -- > Author: Gabriel Galanternik >   INET: ggalanterni_at_tesis-oys.com.ar
    > > Fat City Network
    Services    -- (858) 538-5051  FAX: <FONT size=2>> (858) 538-5051 > San Diego, California        -- Public Internet
    > access / Mailing Lists <FONT
    size=2>> <FONT size=2>--------------------------------------------------------------------
    > 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 <FONT size=2>> (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 <FONT size=2>stephane_paquette_at_yahoo.com

      ---

      Get personalized email addresses from Yahoo! Mail - only $35 a year!  <A target=_blank href="http://personal.mail.yahoo.com/">http://personal.mail.yahoo.com/
  • Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com <FONT size=2>-- Author: =?iso-8859-1?q?paquette=20stephane?=   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 <FONT size=2>-------------------------------------------------------------------- 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).
  • Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com <FONT size=2>-- Author: Gabriel Galanternik <FONT size=2>  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 <FONT size=2>-------------------------------------------------------------------- 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).