在oracle中，您将参数声明为out参数以返回值。请参阅下面的示例并相应地调整您的代码。

In oracle you declare parameter as out parameter to return a value. See below example and tweak your code accordingly.

CREATE OR REPLACE PROCEDURE test_proc (
  p_iKey    IN VARCHAR2,
  p_retVal OUT INTEGER
)
AS
BEGIN
  DELETE FROM myTable
   WHERE theKey = p_iKey;

  IF( SQL%ROWCOUNT >= 1 )
  THEN
    p_retVal := 1;
  ELSE
    p_retVal := 0;
  END IF;
END test_proc;