-
How to excute procedure in toad
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:
Code:
begin
my_procedure;
end;
Highlight all three lines with your cursor and press F9
-
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.
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
|