# How to use and Oracle procedure that return value to Natural **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Natural, Natural-Code-Samples\ **Created:** [May 16, 2012, 11:56pm UTC](https://techcommunity.softwareag.com/t/how-to-use-and-oracle-procedure-that-return-value-to-natural/100575 "2012-05-16T23:56:22Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Kevin\_Brown1](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@Kevin\_Brown1](https://techcommunity.softwareag.com/u/Kevin_Brown1)\ **Post date:** [May 16, 2012, 11:56pm UTC](https://techcommunity.softwareag.com/t/how-to-use-and-oracle-procedure-that-return-value-to-natural/100575/1 "2012-05-16T23:56:22Z")
How can I use CALLDBPROC, RESULT SETS, READ RESULT SET etc. to retrive results returned by Oracle Procedure. My Oracle proceudre have two parameters, my\_proc(cust\_no IN number, cust\_name OUT varchar2). Can I pass cust\_no and get cust\_name using CALLDBPROC from Natural 6.3? Thanks, ---
**Author:** ![Thomas\_Schwade](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/thomas_schwade/32/131_2.png) [@Thomas\_Schwade](https://techcommunity.softwareag.com/u/Thomas_Schwade)\ **Post date:** [June 18, 2012, 1:33pm UTC](https://techcommunity.softwareag.com/t/how-to-use-and-oracle-procedure-that-return-value-to-natural/100575/2 "2012-06-18T13:33:19Z")
> [@Kevin Brown](#): > > How can I use CALLDBPROC, RESULT SETS, READ RESULT SET etc. to retrive results returned by Oracle Procedure. Kevin, RESULT SETS are not supported with Oracle. Regards, Thomas ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 3:01pm UTC](https://techcommunity.softwareag.com/t/how-to-use-and-oracle-procedure-that-return-value-to-natural/100575/3 "2021-04-02T15:01:58Z")