ORA-00900让我抓狂

Question

嗨，我已经创建了一个从数据库中删除客户信息的过程。以下是此操作的代码。

CREATE PROCEDURE remove_customer (customer_id VARCHAR2) IS
BEGIN
    DELETE FROM order_line
    WHERE  order_line.order_id in
    (SELECT order_id FROM placed_order
     WHERE placed_order.customer_id = remove_customer.customer_id
    );

    DELETE FROM placed_order
    WHERE placed_order.customer_id = remove_customer.customer_id;

    DELETE FROM customer
    WHERE customer.customer_id = remove_customer.customer_id;
END;

这是在生产ORA-00900，而我不知道代码出了什么问题？

它也会产生这个错误。

第4行出错: PLS-00302:必须声明组件'ORDER_ID‘

有人发现什么了吗？

谢谢

Answer 1

看起来你应该用

customer_id

而不是

remove_customer.customer_id