# I wish to invoke a Function in Oracle

**URL:** <https://techcommunity.softwareag.com/t/i-wish-to-invoke-a-function-in-oracle/60078>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Linux, Natural-Database-Interfaces-on-Open-Systems\
**Created:** [July 8, 2005, 6:33pm UTC](https://techcommunity.softwareag.com/t/i-wish-to-invoke-a-function-in-oracle/60078 "2005-07-08T18:33:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mike\_Brice](https://avatars.discourse-cdn.com/v4/letter/m/f05b48/32.png) [@Mike\_Brice](https://techcommunity.softwareag.com/u/Mike_Brice)\
**Post date:** [July 8, 2005, 6:33pm UTC](https://techcommunity.softwareag.com/t/i-wish-to-invoke-a-function-in-oracle/60078/1 "2005-07-08T18:33:01Z")

</div>

I am using Entire Access to talk to Oracale and would like to invoke a Function defined in an Oracle package. I have been able to call a stored procedure uisng the following syntax

Process SQL DDM-ORACLE  
\<\< Begin  
packagename.procedurename(  
:U:parm1 ,  
:U:parm2 ,  
:G:results  
);  
End ;

> >

What is the ewuivalent for a function ?

Thanks  
Mike Brice

---

<div class="post-metadata">

**Author:** ![Gyro\_Gearloose](https://avatars.discourse-cdn.com/v4/letter/g/f4b2a3/32.png) [@Gyro\_Gearloose](https://techcommunity.softwareag.com/u/Gyro_Gearloose)\
**Post date:** [July 23, 2005, 9:00pm UTC](https://techcommunity.softwareag.com/t/i-wish-to-invoke-a-function-in-oracle/60078/2 "2005-07-23T21:00:23Z")

</div>

As far as I could find in the documentation, only stored procedures are supported, no functions. But there is a special statement for stored procedures; CALLDBPROC, which seems to be much more comfortable than PROCESS SQL.

Gyro Gearloose, Inventor.

---

<div class="post-metadata">

**Author:** ![Mike\_Brice](https://avatars.discourse-cdn.com/v4/letter/m/f05b48/32.png) [@Mike\_Brice](https://techcommunity.softwareag.com/u/Mike_Brice)\
**Post date:** [July 26, 2005, 5:31pm UTC](https://techcommunity.softwareag.com/t/i-wish-to-invoke-a-function-in-oracle/60078/3 "2005-07-26T17:31:20Z")

</div>

I tried the CALLDBPROC statement and the SQL it generated clearly indicates that it can only invoke a stored procedure and not a function. This is a strange world, there is another tool I use that is happy invoking functions but can not deal with stored procedures and here with Natural I appear to have the inverse.

It really puzzles me that SAG miss things like this.

Thanks for the suggestion.

---

<div class="post-metadata">

**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, 2:40pm UTC](https://techcommunity.softwareag.com/t/i-wish-to-invoke-a-function-in-oracle/60078/4 "2021-04-02T14:40:13Z")

</div>