I need to know how to excute procedure for example rpt_scht in the
toad
Thanks
Printable View
I need to know how to excute procedure for example rpt_scht in the
toad
Thanks
exec rpt_scht and press the execute button - what is the problen you are having
thanks for your reply I'm getting error "ORA 24338: Statement Handle not executed
well you arent being clear on what you have and what you are doing
I'm No TOAD expert but I don't think it supports EXEC. Try this instead:
Highlight all three lines with your cursor and press F9Code:begin
my_procedure;
end;
it does, you can press f5
I execute procedures in TOAD as follows:
Begin
procedure_name ;
end;
Then click on the lightning bolt. That will execute anything in the SQL window as a script.