Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling Oracle SP
Message
From
10/07/2000 23:21:33
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Calling Oracle SP
Miscellaneous
Thread ID:
00390579
Message ID:
00390579
Views:
55
Hi,
I want to call Oracle stored procedures. My code goes like this but does not work.

iConn = sqlconnect()
if iConn > 0
iErr = sqlexec(iConn,'execute test.sp_test_call;')
if Err > 0
wait window 'Stored procedure successful'
else
wait window 'Stored procedure not successful'
endif
endif
sqldisconnect(iConn)

Please give inputs if my syntax is indeed incorrect.

Thanks, Ramil 7/10
ramil
~~ learning to stand still
Next
Reply
Map
View

Click here to load this message in the networking platform