打开oracle数据库oe,database - Oracle数据库11g：OE.ORDERS表不存在 - SO中文参考 - www.soinside.com...

我尝试创建Oracle数据库11g的一个简单的功能，但它给我下面的错误。现在看来似乎找不到OE.ORDERS表。请您帮忙！

谢谢！

码：

--Create following function as SYS

CREATE OR REPLACE FUNCTION get_bal(acc_no IN NUMBER)

RETURN NUMBER

IS acc_bal NUMBER(11,2);

BEGIN

SELECT oe.orders.order_total

INTO acc_bal

FROM oe.orders

WHERE oe.orders.customer_id = acc_no;

RETURN(acc_bal);

END;

/

SELECT get_bal(170) AS Balance FROM dual;

错误：

> ORA-06575: Package or function GET_BAL is in an invalid state

> 06575. 00000 - "Package or function %s is in an invalid state"

> *Cause: A SQL statement references a PL/SQL function that is in an

> invalid state. Oracle attempted to compile the function, but

> detected errors.

> *Action: Check the SQL statement and the PL/SQL function for syntax

> errors or incorrectly assigned, or missing, privileges for a

> referenced object. Error at Line: 28 Column: 7