| returning and accessing pl/sql tables in forms [message #480443] |
Sun, 24 October 2010 14:00 |
raghug
Messages: 2
Registered: June 2010
Location: Unites States
|
Junior Member |
|
|
Can any one tell me how to select row from pl/sql table and display it in my form.
I have a packagein pl.sql which will return multiple address in pl/sql table.I have to display all these addresses in oracle oracle form . When user enter address in the form and click on verify button . pl/sql package should be called and it should return multiple alternate addresses. then user can coose one address and this addrss should be stored in the address fileds of form.
I displayed all the mulitple addresses by creating a new block through layout wizarde and it has option to select stored proceudre and on button click , i called this bloack with execute query.
But i had problem with choosing one address and store thatg address in actual form.
Can any one please help me on how to do this.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
