Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling Oracle Packages from SQL Passthrough
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Calling Oracle Packages from SQL Passthrough
Miscellaneous
Thread ID:
00525330
Message ID:
00525330
Views:
40
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
What is Wisdom?
Wisdom - The ability to respond to any situation according to God's Plan.
Therefore:
USE Wisdom IN Everything ORDER priority AS Knowledge
SELECT Knowledge
BROWSE FOR Understanding WHERE Wisdom=Guide

LeRoy Jackson
Next
Reply
Map
View

Click here to load this message in the networking platform