Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to call oracle procedure in visual foxpro
Message
From
11/11/2000 10:37:17
Paul De Niverville
Deniverville Econometric Research Ltd.
Victoria, British Columbia, Canada
 
 
To
10/11/2000 23:59:51
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00440668
Message ID:
00440707
Views:
14
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
Previous
Reply
Map
View

Click here to load this message in the networking platform