PLSQL过程执行错误无效语句 [英] PLSQL procedure execution error invalid statement

问题描述

我正在关注有关PL/SQL的教程 http://www.plsqltutorial.com/plsql -procedure/.我已经在apex上使用以下代码创建了过程:

I'm following a tutorial on PL/SQL http://www.plsqltutorial.com/plsql-procedure/. I have created procedure with the following code on apex:

CREATE OR REPLACE PROCEDURE adjust_salary(
    in_employee_id IN EMPLOYEES.EMPLOYEE_ID%TYPE,
    in_percent IN NUMBER
) IS
BEGIN
    UPDATE EMPLOYEES
    SET salary = salary + salary * in_percent / 100
    WHERE employee_id = in_employee_id;
END;

但是，当我尝试运行时

exec adjust_salary(200,5);

我出错了

ORA-00900: invalid SQL statement.  

有什么问题以及如何解决?

What is the problem and how to fix it?

推荐答案

我认为您的PL/SQL没问题.您应该检查是否安装了过程选件:

I see nothing wrong with your PL/SQL. You should check to see if the Procedural Option is installed:

http://www.techonthenet.com/oracle/errors/ora00900.php

这篇关于PLSQL过程执行错误无效语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！