PL-SQL questions ? Please give a hand !!

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/      \_     /
  /   / |____________________________________________| \    \
 /   /                                                   \    \