Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating Oracle stored procedures
Message
From
06/07/2001 18:15:07
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Creating Oracle stored procedures
Miscellaneous
Thread ID:
00527661
Message ID:
00527661
Views:
49
Hello
Why does this not work?
Creation of stored procedures in oracle via ODBC

text="create or replace procedure easy as begin select * from dual;end;"
result=sqlexec(myoracleconn,text)

Result is always -1.
The procedure is marked "invalid" in oracle DBA studio
Just touching any single character in Oracle DBA studio and recompiling marks it "valid".

Using Oracle ODBC 8.7.2

Any ideas?
Next
Reply
Map
View

Click here to load this message in the networking platform