Stored Procedure not executing in soatest - giving error message
- I’m having a problem with the DB Tool, where a stored procedure is not working as expected. The same exact stored procedure is working on Toad for Oracle, and I’m able to get the query result I expect. Using the DB Tool in SOAtest, I get the following error:
- “Error Message:
- ORA-00922: missing or invalid option
An invalid option was specified in defining a column or storage clause. The valid option in
specifying a column is NOT NULL to specify that the column cannot contain any NULL values. Only
constraints may follow the datatype. Specifying a maximum length on a DATE or LONG datatype also
causes this error.
Correct the syntax. Remove the erroneous option or length specification from the column or storage
There are no differences in the syntax used in Toad and in SOAtest.
What am I missing?