Stored Procedure not executing in soatest - giving error message
- Hello,
- 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
- 42000
Additional Details:
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.
Action:
Correct the syntax. Remove the erroneous option or length specification from the column or storage
specification.”
There are no differences in the syntax used in Toad and in SOAtest.
What am I missing?
Best,
Kartik
Comments
-
Unfortunately that error can happen for many different reasons, so it's hard to say why it's not working from SOAtest. Can you shared the syntax of your stored procedure?
0 -
SET SERVEROUTPUT ON SIZE UNLIMITED;
VARIABLE c_l REFCURSOR;DECLARE
P_L NUMBER;
P_T VARCHAR (2000);
EC NUMBER;
ED VARCHAR2 (32767);
BEGIN
P_L := 'Enter value here';
P_T := 'Enter Value here';
EC := NULL;
ED := NULL;
MD_WS.L.Get_L (P_L,
P_T,
:c_l,
EC,
ED);
DS_OUTPUT.Put_Line ('EC = ' || TO_CHAR (EC));
DS_OUTPUT.Put_Line ('ED = ' || ED);
END;PRINT c_l
0 -
"set serveroutput on" is not supported in the JDBC driver, which is what SOAtest uses to connect to the database. Please see https://stackoverflow.com/questions/30574516/calling-a-stored-procedure-using-oracle-sql-developer for an explanation.
0