Take a look at mskb#Q149882 and mskb#Q221189.

>I'm trying to run a Oracle 8i package that contains a function that returns as single numeric value. I can run SQL strings from SQLEXEC, but can't get these darned sprocs working. The package is compiled and I've tested it from SQL+, so it's not that..I've tried the following syntax:
>
>local rtn as integer
>
>rtn = sqlexec(cn,'MYSCHEME.MYPACKAGE.MYFUNCTION')
>
>and
>
>rtn = sqlexec(cn,'{CALL MYSCHEME.MYPACKAGE.MYFUNCTION}')
>
>Any ideas folks???
>
>Thanks in advance..
>
>Pablo