Home » Developer & Programmer » Forms » using varray in oracle forms
using varray in oracle forms [message #440055] Wed, 20 January 2010 14:40 Go to next message
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
.
Re: using varray in oracle forms [message #444939 is a reply to message #440055] Wed, 24 February 2010 21:33 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Which version of Forms are you using?

David
Previous Topic: web.show_document from oracle6i
Next Topic: WEBUTIL_FILE_TRANSFER.AS_TO_CLIENT_WITH_PROGRESS
Goto Forum:
  


Current Time: Sun Dec 04 22:46:40 CST 2016

Total time taken to generate the page: 0.20947 seconds