调用具有数据类型%TYPE参数的过程时,oracle参数类型应该是什么? [英] What should be the oracle parameter type while calling procedure which has parameter with data type %TYPE?
问题描述
调用具有数据类型%TYPE参数的过程时oracle参数类型应该是什么?
我有一个过程,
程序getdata(
p_id ORDER_XX.XX_ID%TYPE,
p_xx ORDER_XX.XX__NUMBER%TYPE,
p_yy ORDER_XX.XX_DATE%TYPE,
p_xx ORDER_XX.XX_DATE%TYPE,
p_cr OUT cccc_refcursor}
从前端调用此过程时应该是p_id,P_xx等的oracle参数类型?
What should be the oracle parameter type while calling procedure which has parameter with data type %TYPE?
I have one procedure,
PROCEDURE getdata(
p_id ORDER_XX.XX_ID%TYPE,
p_xx ORDER_XX.XX__NUMBER%TYPE,
p_yy ORDER_XX.XX_DATE%TYPE,
p_xx ORDER_XX.XX_DATE%TYPE,
p_cr OUT cccc_refcursor}
while calling this procedure from front end what should be the oracle parameter type for p_id,P_xx etc?
推荐答案
它应该是相同的键入作为对象的基础类型。
ORDER_MONITOR.ORDER_ID%TYPE
应该是相同的键入字段ORDER_MONITOR.ORDER_ID。很可能基于名称一个数字类型。
%TYPE只是意味着,使用左边对象的类型。
It should be the same type as the underlying type of the object.
ORDER_MONITOR.ORDER_ID%TYPE
Should be the same type as the field ORDER_MONITOR.ORDER_ID. Most likely based on the name a Number type.
The "%TYPE" just means, use the type of the object to the left.
OracleType.Number
Hogan
Hogan
这篇关于调用具有数据类型%TYPE参数的过程时,oracle参数类型应该是什么?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!