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