是我描述的不够准确,数据库中是这样的 type pagination is ref cursor;--定义结果集类型 PROCEDURE P_GET_TASK_COUNT ( TASK_DATA IN OUT PAGINATION ) Open for TASK_DATA SELECT COUNT(*), b.owner_username, 'XXXX' FROM xxxx_v_report a ,xxxx_owner b WHERE a.report_id = b.report_id GROUP BY owner_username; 返回给Java一个cursor类型的,在Java中能不能直接把返回的数据一下插入到一张表中 比如:insert into A select * from B
type pagination is ref cursor;--定义结果集类型
PROCEDURE P_GET_TASK_COUNT (
TASK_DATA IN OUT PAGINATION
)
Open for TASK_DATA
SELECT COUNT(*), b.owner_username, 'XXXX'
FROM xxxx_v_report a
,xxxx_owner b
WHERE a.report_id = b.report_id
GROUP BY owner_username;
返回给Java一个cursor类型的,在Java中能不能直接把返回的数据一下插入到一张表中
比如:insert into A select * from B