If you can do it on the Oracle side you should be able to send the command to to the server through Passthrough and have it work. The only difficulty might be what some of the ODBC drivers will handle. Another thought, if it is feasible, might be to make a view based on your SQL statement that has the embedded statement for a column. Then all you would have to pass to Oracle through ODBC would be SELECT * FROM < table_name > ... or something to that effect.

HTH,
George

>Hello Everyone!!
>I am starting a new project that will pull information directly from Oracle. I have been using SQL PASSTHROUGH for the task. However, it has now come to my attention that some of the columns that we thought were in the table are really made up from some packages that were previously written.
>For example to get the commodity column, if we were on oracle we would call the package with the Parameter of the product_code inside of a select statment and it will spit out the commodity.
>
>Question- In side of VFP's SQL passthrough, can I call a package in my sqlexecute statement or is it a lost cause?
>
>Thanks in advance