but I get "ORA-17034: Non supported SQL92 token at position".
When the call succeeds it returns TRUE and the inout is then empty or null (I don't really know). When the call fails it returns "FALSE" and the inout value is a description of what went wrong.
I know it is not complete, and that is my problem! I really can't find the right solution. Anyone?
Regards,
Thomas
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I not that good at PL/SQL and also SQLUnit is somewhat new to me, so now I give on the following and turn to the oracles ;)
I need to test the following function defined as:
FUNCTION create (
pi_user IN VARCHAR2,
pi_role IN VARCHAR2,
pi_pwd IN VARCHAR2,
pio_rc IN OUT VARCHAR2
)
RETURN BOOLEAN;
I have tried with this:
<test name="Correkt password" failure-message="FAIL">
<call>
<stmt>{INVROLLE.opret('us', 'gr', 'pw', ?)}</stmt>
<param id="1" name="rc" type="VARCHAR" inout="inout">''</param>
</call>
<result>
<outparam id="1" name='rc' type="VARCHAR">NULL</outparam>
</result>
</test>
but I get "ORA-17034: Non supported SQL92 token at position".
When the call succeeds it returns TRUE and the inout is then empty or null (I don't really know). When the call fails it returns "FALSE" and the inout value is a description of what went wrong.
I know it is not complete, and that is my problem! I really can't find the right solution. Anyone?
Regards,
Thomas