如何执行oracle存储过程?
我使用的是oracle 10g express 版本.它为数据库开发人员提供了一个很好的用户界面.但是我在执行存储过程时遇到了一些问题.
I am using oracle 10g express edition. It has a nice ui for db developers. But i am facing some problems executing stored procedures.
程序:
create or replace procedure temp_proc is
begin
DBMS_OUTPUT.PUT_LINE('Test');
end
创建成功.但是当我执行时:
it is created successfully. But when i execute:
执行 temp_proc;
显示ORA-00900:无效的SQL语句
所以这里需要帮助
推荐答案
Execute 是 sql*plus 语法 .. 尝试将您的调用包装在 begin .. end 中:
Execute is sql*plus syntax .. try wrapping your call in begin .. end like this:
begin
temp_proc;
end;
(虽然 Jeffrey 说这在 APEX 中不起作用..但是你试图让它在 SQLDeveloper 中运行..尝试那里的运行"菜单.)
(Although Jeffrey says this doesn't work in APEX .. but you're trying to get this to run in SQLDeveloper .. try the 'Run' menu there.)
相关文章