>So in other words I could do something like:
>

>lcSql = "SELECT *,SOMPACKAGE(PARAMETERS,PARAMETERS) AS ColumnWhatEver "
>lcSql = lcSql + " FROM SomeTableInOracle WHERE ...."
>
>lnResult = SQLEXEC(lnConn,lcSql,'MYNEWCURSOR')
>

>Would this be feasible?

Oh, you want to use it to return a value and not a record set. Yes, this is very feasible. You will have to change the Package call to the Package.Function call but that the only problem I see.

Think of a package as a Procedure file with functions embedded in it. Since there is no SET PROCEDURE TO in Oracle, you need to specify the package and the embedded function.

SomePackage.SomeFunction(Parameter, Parameter) as ColumnWhatEver