我在系统定义了一个存储存储如下:
PROCEDURE inv_czjk_sjjc(p_date_from IN VARCHAR2,
p_date_to IN VARCHAR2,
P_ORGANIZATION_ID IN NUMBER
) is
l_date_from DATE := to_date(p_date_from, 'yyyy-mm-dd hh24:mi:ss');
l_date_to DATE := to_date(p_date_to, 'yyyy-mm-dd hh24:mi:ss');
CURSOR ghj_czjk IS
SELECT A.SEGMENT1 物料编码,
A.DESCRIPTION 物料描述,
B.ISSUE_QUANTITY 发货数量,
B.SUBINV_CODE 发出仓库,
(SELECT SUM(D.PRIMARY_TRANSACTION_QUANTITY)
from inv.mtl_onhand_quantities_detail d --inv.mtl_system_items_b a
WHERE b.ORGANIZATION_ID = D.ORGANIZATION_ID
AND A.INVENTORY_ITEM_ID = D.INVENTORY_ITEM_ID
AND D.SUBINVENTORY_CODE = b.subinv_code
GROUP BY A.SEGMENT1, A.DESCRIPTION, D.SUBINVENTORY_CODE) 现有量,
B.TO_SUBINV_CODE 接收仓库,
B.TRANSACTION_DATE 导入时间,
B.WORK_SHIFITS 班次,
B.WORK_GROUP 班组,
B.APPLY_ID 申请ID,
C.USER_NAME 导入人,
DECODE(B.TRANSACTION_TYPE_ID, '3', '组织间转移', '子库存转移') 导入结果,
DECODE(B.ISSUE_TYPE, 'I', '发料', '退货') 收发方式,
DECODE(B.TRANSACTION_STATUS, 'COMPLETE', '已处理', '待处理') 处理结果,
B.INTERFACE_MESSAGE 错误原因
FROM INV.MTL_SYSTEM_ITEMS_B A,
apps.TRI_ITEM_ISSUE_INTERFACE B,
apps.FND_USER C
WHERE A.ORGANIZATION_ID = b.organization_id
AND A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
AND B.CREATED_BY = C.USER_ID
and b.transaction_date between l_date_from
and l_date_to
and b.organization_id = P_ORGANIZATION_ID
--and c.user_name = erp_name
order by 7;
但是定义请求运行时报错错误如下:
**Starts**09-11-2011 09:55:35
FDPSTP 中出现 ORACLE 错误 6550
原因:由于 ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'INV_CZJK_SJJC'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
, FDPSTP 失败。
请高手给看看我的错误在哪里 我对参数这块不熟悉请指点一下