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
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_at_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_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:
> http://www.orafaq.com
> --
> Author: Chandini Paterson
> INET: chandini.paterson_at_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_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:
> http://www.orafaq.com
> --
> 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).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
Received on Wed Jan 31 2001 - 04:31:37 CST
