-
Can we exec a procedure by using execute immediate
Radhakrishnan.M
-
You can EXECUTE IMMEDIATE pl/sql block, that call to procedure.
-
begin
execute immediate 'call sp_proc()';
end;
Cheers!
OraKid.
-
What is the advantage of using 'Execute Immediate' over 'Execute'?
-
this will be helpfull when u create a whole pl/sql block dynamically. i this case i cannot use the conventional way.
if iam wrong do correct me
Cheers!
OraKid.
-
Hi there,
my preferred one:
EXECUTE IMMEDIATE 'BEGIN scott.do_it; END;'
cu
6502
-
originally posted by Raminder:
------------------------
What is the advantage of using 'Execute Immediate' over 'Execute'?
------------------------
with execute immediate you can execute a sql or a procedure dynamically, which can be very advantageous if your sql or procedure needs variable or parameter that is not fixed.
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
|