Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to call oracle procedure in visual foxpro
Message
De
11/11/2000 10:37:17
Paul De Niverville
Deniverville Econometric Research Ltd.
Victoria, Colombie Britannique, Canada
 
 
À
10/11/2000 23:59:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00440668
Message ID:
00440707
Vues:
21
Hi,

Have a look at SQL Passthrough in VFP help.

Open a connection to the database.

x = sqlconnect()

Then pass any valid sqlplus statement:

y = sqlexec(x,'any valid sqlplus statement')

Good luck,

Paul


>I wrote a procedure in sqlplus:
>
>create or replace procedure thuan (m1 in number,m2 in number, m3 out number)
>as
> begin
> m3:=m1+m2;
> end;
>
>Can you tell me how to call this procedure in visual foxpro
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform