-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|