Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating Oracle stored procedures
Message
 
 
To
06/07/2001 18:15:07
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00527661
Message ID:
00527827
Views:
20
>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?

After the last semi-colon, end the string with / [forward-slash]
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform