过程和函数中的参数的类型只需要声明类型,而不用指定长度(精度);
带参数的cursor的参数也只需要声明类型,而不用指定长度(精度);
只有单独声明的变量需要指定长度(精度);
如:
CURSOR C_SELECT2 (ResID VARCHAR2, ResNo VARCHAR2);
res_303 (sUid IN VARCHAR2,
sPw IN VARCHAR2,
sApp IN VARCHAR2,
sReqNo IN VARCHAR2,
nMaxCount IN NUMBER,
nPageCount IN NUMBER,
typData IN OUT NOCOPY USS_TBL,
po_fhz OUT VARCHAR2,
po_msg OUT VARCHAR2)
v_data VARCHAR2(1000)
带参数的cursor的参数也只需要声明类型,而不用指定长度(精度);
只有单独声明的变量需要指定长度(精度);
如:
CURSOR C_SELECT2 (ResID VARCHAR2, ResNo VARCHAR2);
res_303 (sUid IN VARCHAR2,
sPw IN VARCHAR2,
sApp IN VARCHAR2,
sReqNo IN VARCHAR2,
nMaxCount IN NUMBER,
nPageCount IN NUMBER,
typData IN OUT NOCOPY USS_TBL,
po_fhz OUT VARCHAR2,
po_msg OUT VARCHAR2)
v_data VARCHAR2(1000)