贺跃辉(贺跃辉) 11:11:16
PROCEDURE proc_lastrecord (
prmdormcode IN VARCHAR2,
prmday IN VARCHAR2,
io_allrec OUT ref_cursor )
AS
allrec ref_cursor
;
BEGIN
OPEN allrec FOR
SELECT v_s_c.studentcode, v_s_c.dormcode, v_s_c.roomno, v_s_c.posno,
v_dep.dpname, d.lastopertime, d.DAY, b.NAME, b.sex,
b.idcardno
FROM v_studentcode_customerid_dorm v_s_c,
v_dep,
dorm_last d,
base_customers b
WHERE v_s_c.studentcode = b.outid
AND b.custdept = v_dep.dpcode
AND v_s_c.customerid = b.customerid
AND v_s_c.customerid = d.customerid
AND b.customerid = d.customerid
AND d.DAY = prmday
AND v_s_c.dormcode IN (prmdormcode); io_allrec := allrec;
END;
程序中调用这个存储过程 ,要传进去 prmdormcode 等于 类似 "3,5,7,9"一组楼号集合字串,怎么办?
现在一次只能传一个数字
PROCEDURE proc_lastrecord (
prmdormcode IN VARCHAR2,
prmday IN VARCHAR2,
io_allrec OUT ref_cursor )
AS
allrec ref_cursor
;
BEGIN
OPEN allrec FOR
SELECT v_s_c.studentcode, v_s_c.dormcode, v_s_c.roomno, v_s_c.posno,
v_dep.dpname, d.lastopertime, d.DAY, b.NAME, b.sex,
b.idcardno
FROM v_studentcode_customerid_dorm v_s_c,
v_dep,
dorm_last d,
base_customers b
WHERE v_s_c.studentcode = b.outid
AND b.custdept = v_dep.dpcode
AND v_s_c.customerid = b.customerid
AND v_s_c.customerid = d.customerid
AND b.customerid = d.customerid
AND d.DAY = prmday
AND v_s_c.dormcode IN (prmdormcode); io_allrec := allrec;
END;
程序中调用这个存储过程 ,要传进去 prmdormcode 等于 类似 "3,5,7,9"一组楼号集合字串,怎么办?
现在一次只能传一个数字
解决方案 »
- oracle在插入数据的时候,如何以每10000条提交一次
- 怎么把两条记录通过一条sql 查询出来?
- FRM-41839: 在临时记录缓冲区文件/tmp/P-ic7a.tmp中磁盘的输入/输入错误
- package 中有clob变量,效率变慢
- Linux X Window编程,如何启动X Server
- 远程导出数据库的表结构,而不导出数据?急
- 一个复杂查询语句请教!关联3个表!100分贴!
- IBM P610 AIX5:0509-124 The program is a discontinued 64-bit object file问题请教,在线等待,急急急
- 请问那里有plsql的资料,最好是编程实例的!!急
- oracle816:在启动OracleoraHomeManagementServer时提示:在本地计算机无法启动OracleoraHomeManagementServer服务。错误997:重叠I/O操作
- 难题啊,迷惑不解
- 请大家帮我解决一个问题!谢谢
...
AND instr( ','||prmdormcode||',', ','||v_s_c.dormcode||',' )>0