Gaigo - 2007-11-01

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