| pl/sql tables [message #478300] |
Thu, 07 October 2010 13:55  |
anish0403
Messages: 12
Registered: December 2009
Location: memphis
|
Junior Member |
|
|
Hi,
I am working on a webservice call from ORacle.
Here is the scenario what i am currently doing.
I have a button on my form application called verify.Wheni click on verify button , a pl.sql procedure should be invoked and that procedure will call .net webserive to validate the address , the result from the webserivce will be in xml.
I have to extract the xml into some variables and return these varibles to Forms application .
I am plannig to use pl/sql table to store the result from web service call.
here are the output values:
Customer_Id varchar2(20),
ErrorCode varchar2(30),
ErrorDesc varchar2(3000),
Fcount number,
FErrorCode -- this is array,-- if fcount >1 then these values will be repeted.
FErrorDesc -- this is array,
FStatusCode -- this is array,
FStatusDesc -- this is array,
Street varchar2(3000),
Street2 varchar2(3000),
Suite varchar2(20),
City varchar2(20),
State varchar2(2),
Zip_Code varchar2(10)
.
can anyone of you help me to create record type and pl/sql table for these.
I want to return pl/sql table as a out parameter to the form.
|
|
|
|
| pl/sql tables [message #478302 is a reply to message #478300] |
Thu, 07 October 2010 14:18  |
anish0403
Messages: 12
Registered: December 2009
Location: memphis
|
Junior Member |
|
|
Hi,
I need some help in creating record/plsql tables.
I have form application which has button called "verify".
when i click that button it should invoke pl/sql procedure which inturn calls a webservice to verify the address and correct it.
Webservice will return xml result and i have to store those results in pl/sql table or record and send that result back to form application .
I had problem with storing results , some of my return variables have array's in it. like same xml tag will repeat more than one time.
Below are the results of the webservice
Customer_Id varchar2(20),
ErrorCode varchar2(30),
ErrorDesc varchar2(3000),
Fcount number,
FErrorCode -- this is array,
FErrorDesc -- this is array,
FStatusCode -- this is array,
FStatusDesc -- this is array,
Street varchar2(3000),
Street2 varchar2(3000),
Suite varchar2(20),
City varchar2(20),
State varchar2(2),
Zip_Code varchar2(10)
please help me how to create the return variable and pass it along to form application.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
