Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling Oracle Packages from SQL Passthrough
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Calling Oracle Packages from SQL Passthrough
Divers
Thread ID:
00525330
Message ID:
00525330
Vues:
41
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform