This content has been marked as final. Show 3 replies
Message was edited by:
As I know, there's no solution to getting the precedure return value. It's the limitation on Personalization. Pls consider to use CUSTOM.pll instead.
Reference link (CUSTOM.pll versus Forms Personalization ):
I want to return value from a package procedure to
a Form field after doing some calculation on the
I am calling this package procedure through form
personalization of that form.
Can any one suggest How to do this ???
This is how I did when I had to get an out value out of a stored procedure.
1. Create a package level global variable, lets call it g_customer.
2. Inside your procedure code, assign the value for g_customer.
3. Create a new public function inside the package without any parameters. Lets call it get_customer. All it does is return the global variable defined in Step1. The function code will be
function get_customer return varchar2 is
4.In Forms Personalization, write another action step after the call to the procedure as follows:
Action Type: Property
Object Type: Global Variable or Item (depending on what you want to do with the returned item)
Target Object: GLobal Variable name or Item Name (depending on what you selected above)
Property Name: Value
Hope that helps,