I need to get the result of executing a function stored in my oracle database, is it possible?

Thanks,

Please state your requirements clearly.

I am not sure if you can call a function from your Oracle database, but you can call the Oracle Libraries, SQL commands/scripts from BaaN.

Refer to the links-

accessing external tables (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=6965&highlight=sql)

stored procedure oracle (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=6448&highlight=sql)

I need to get the result of executing a function stored in my oracle database, is it possible?
You can just add the 2 statements at the beginning of the SQL script if you like to have output stored in a file -

whenever sqlerror exit sqlcode
spool /app/common/home/bsp/output.log

What function are you trying to call? And where are you wanting to call it from and to?

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.

Yes, of course its possible. Thats what functions are for! :)