Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> PL-SQL questions ? Please give a hand !!
Hello,
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 _ | _) )_Received on Sun Jun 20 1999 - 07:31:11 CDT
(((\ \> |/ ) ( \| </ /)))
(\\\\ \_/ / E-Mail : d951686_at_sftw.umac.mo \ \_/ ////) \ / \ / \ _/ http://www.sftw.umac.mo/~d951686/ \_ / / / |____________________________________________| \ \ / / \ \