oracle 如何在toad中执行程序？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7080192/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to execute procedure in toad?
提问by Victor
I have a oracle sql script with following contents: A Function and 3 procedures. One procedure (MAIN) internally will call the other 2 procs and the function.
我有一个包含以下内容的 oracle sql 脚本：一个函数和 3 个程序。一个过程 (MAIN) 将在内部调用其他 2 个过程和函数。
Now through TOAD, how can I execute or call the the MAIN procedure?
现在通过 TOAD，我如何执行或调用 MAIN 过程？
回答by Ollie
This should do it:
这应该这样做：
EXECUTE main;
If you want it in a PL/SQL block for some reason:
如果您出于某种原因想要在 PL/SQL 块中使用它：
BEGIN
main;
END;
Of course, this assumes that you have direct access to the main procedure itself.
当然，这假设您可以直接访问主程序本身。
Is that what you meant or have I missed something?
这是你的意思还是我错过了什么？
If I have then this might be helpful: http://www.informit.com/articles/article.aspx?p=31544&seqNum=10
如果我有那么这可能会有所帮助：http: //www.informit.com/articles/article.aspx?p =31544& seqNum=10
