>Sorry, I oversimplified the sql statement, the sql sample shown in the previous message does not work.
>But even with syntactically correct sql, the procedure creation process fails.

Maybe an account you are using for ODBS connection to oracle doesnt have adequate rights?

What error ODBC returns? You can use AERROR() function to get ODBC error.