| using varray in oracle forms [message #440055] |
Wed, 20 January 2010 14:40  |
anish0403
Messages: 12
Registered: December 2009
Location: memphis
|
Junior Member |
|
|
Hi ,
I have problem in using varray in oracle forms . i have written pl/sql procedure inside database and calling it inside oracle forms. This procedure uses varray type variable as out parameter so i declared varray inside oracle forms to get that values . But i am getting compilation errors.
Procedure inside forms:
PROCEDURE address_validation IS
TYPE t_sfe IS VARRAY(20) OF VARCHAR2(200);
p_customerid varchar2(20);
p_sr_errorcode varchar2(5000);
p_sr_errordesc varchar2(5000);
p_sr_statuscode varchar2(5000);
p_sr_statusdesc varchar2(5000);
p_ad_fcount varchar2(5000);
p_ad_code t_sfe ;
--p_ad_desc tfe_sf ;
--p_ad_source tfe_sf;
--p_ad_detail tfe_sf;
p_ad_errorcode varchar2(5000);
p_ad_errordesc varchar2(5000);
p_ad_statuscode varchar2(5000);
p_ad_statusdesc varchar2(5000);
p_ad_street varchar2(5000);
p_ad_street2 varchar2(5000);
p_ad_suite varchar2(5000);
p_ad_city varchar2(5000);
p_ad_state varchar2(5000);
p_ad_zip5 varchar2(5000);
BEGIN
tfe_address_wovarray('1111111111',
'true',
'true',
'false',
'1.0',
'Request',
'20',
'ABCD',
'3599 Eagle Trace ',
' ',
'201',
'Memphis',
'TN',
'38125',
'USA',
P_CUSTOMERID,
P_SR_ERRORCODE,
P_SR_ERRORDESC,
P_SR_STATUSCODE
,P_SR_STATUSDESC,
P_AD_FCOUNT,
p_ad_code,
-- p_ad_desc,
-- p_ad_source,
-- p_ad_detail,
p_ad_errorcode,
p_ad_errordesc,
p_ad_statuscode,
p_ad_statusdesc,
p_ad_street,
p_ad_street2,
p_ad_suite,
p_ad_city,
p_ad_state ,
p_ad_zip5 );
END;
When i compile this i am getting error like :
"wrong number/type of arguments in call to "
It has something to do with varray varible . "tfe_address_wovarray" this procedure is having in & out variables and p_ad_code is out varible whihc is of varray .
Can you please tell me where i am doing wrong .
APpreciate your help.
Thanks
.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
