Skip to Content
0
Former Member
Nov 23, 2005 at 03:36 PM

Executing stored function using Native SQL

810 Views

In SAP documentation, I can see how to execute an Oracle stored procedure in an external database using:

EXEC SQL.

EXECUTE PROCEDURE procname

ENDEXEC.

I want to execute a stored FUNCTION within a package. I have tried executing it using the syntax for PROCEDURE above and get a "ORA-06550 wrong type or number of arguments" error. Since the function has one argument in and one argument out, I think I am counting the number of arguments correctly. Has anyone executed from within ABAP an Oracle function stored in an external database?

Thanks

Janice Ishee