Home » SQL & PL/SQL » SQL & PL/SQL » Problem with varray type out parameter (splitted from "xmltype conversion" topic)
Problem with varray type out parameter (splitted from "xmltype conversion" topic) [message #440053] Wed, 20 January 2010 14:36 Go to next message
anish0403
Messages: 12
Registered: December 2009
Location: memphis
Junior Member
Hi Mich,

I have one more question now.
I had defined a varray type variable inside oracle forms builder likr this :

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 there whihc is of varray .

Can you please tell me where i am doing wrong .

APpreciate your help.

Thanks
.

[Updated on: Wed, 20 January 2010 14:37]

Report message to a moderator

Re: xmltype conversion [message #440099 is a reply to message #440053] Thu, 21 January 2010 01:30 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please do not continue on a topic that has nothing to do with what you now post.
Also please format your post as I did it in all the previous answers.
Remove the lines in comment they are useless and code is harder to read and assimilate.

Give the description of the called procedure.
Use SQL*Plus and copy and paste the session that shows the error.
We have not your objects and so can't reproduce and see what you get.

Regards
Michel

Previous Topic: Referering Long value in triger
Next Topic: invalid group by query
Goto Forum:
  


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

Total time taken to generate the page: 0.09460 seconds