Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> PL-SQL questions ? Please give a hand !!

PL-SQL questions ? Please give a hand !!

From: Chow Hoi Ka, Eric <d951686_at_sftw.umac.mo>
Date: Sun, 20 Jun 1999 20:31:11 +0800
Message-ID: <376CDF0F.F8DD6B89@sftw.umac.mo>


Hello,

  1. Does PL-SQL has ARRAY ??? How ??

Is it possible to do as following ?

tmpVar := 'procA';
exec tmpVar;

It means that I want to execute another store procedure but the procedure name will be changed frequently. Therefore, I want to use a variable to store the procedure name.
Such as the above. tmpVar is storing the procedure name 'procA'. So, how to implement this ???

Best regards,
Eric

--

     _                                                  _
    / ) |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ( \
   / /  |                                            |  \ \
 _( /_  | _   Chow Hoi Ka, Eric                    _ |  _) )_

(((\ \> |/ ) ( \| </ /)))
(\\\\ \_/ / E-Mail : d951686_at_sftw.umac.mo \ \_/ ////) \ / \ / \ _/ http://www.sftw.umac.mo/~d951686/ \_ / / / |____________________________________________| \ \ / / \ \
Received on Sun Jun 20 1999 - 07:31:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US