>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