怎么有这句话?“SELECT NODE_ID, NODE_LEVEL, NODE_INDEX, LABEL FROM STRUCTURE WHERE NODE_LEVEL = MYNODE_LEVEL ORDER BY NODE_INDEX;”在存储过程中不能有不带INTO子句的SELECT!
SELECT NODE_ID, NODE_LEVEL, NODE_INDEX, LABEL FROM STRUCTURE WHERE NODE_LEVEL = MYNODE_LEVEL ORDER BY NODE_INDEX; ????
SELECT NODE_ID, NODE_LEVEL, NODE_INDEX, LABEL FROM STRUCTURE WHERE NODE_LEVEL = MYNODE_LEVEL ORDER BY NODE_INDEX 沒有可以返回這些值的參數或者表
那么如何将一个select纪录集通过存储过程返回回来!
CREATE OR REPLACE package pkg_testastype cur_test is ref cursor; -- 定义一个cursor的type procedure proc_test(test_out out cur_test);end pkg_test; / CREATE OR REPLACE PACKAGE BODY pkg_test as procedure proc_test(test_out out cur_test) IS BEGIN OPEN test_out FOR SELECT ask_id FROM match_line_order; END; END pkg_test; /
????
procedure proc_test(test_out out cur_test);end pkg_test;
/
CREATE OR REPLACE PACKAGE BODY pkg_test as
procedure proc_test(test_out out cur_test)
IS
BEGIN
OPEN test_out FOR
SELECT ask_id
FROM match_line_order;
END;
END pkg_test;
/