calling varying stored proc
i have to make a call from a stored proc to a stored proc that may or may not exist
like this:
------------------
if exists
(select bla from dba_objects where name like 'spcstored' )
then
exec or call ' spcstored'
end if
-----------------------------------
now this is not so complex but if spcstored
does not exist you cannot compile this stored proc
so you must put the name of the spcstored i want to call
in some kind of variable to exclude the compile error. and then execute it
can anoone solve this problem?
Frans-jan Wagemakers