这就是我到目前为止所拥有的.
create or replace PROCEDURE Testing ( iKey IN VARCHAR2 ) AS BEGIN delete from MyTable WHERE TheKey = iKey; END Testing;
我已经尝试过放置RETURNS INTEGER,但是sproc不会编译.
create or replace FUNCTION Testing ( iKey IN VARCHAR2 ) RETURN INTEGER AS BEGIN delete from MyTable WHERE TheKey = iKey; RETURN sql%ROWCOUNT; END Testing;
这应该工作
