stored procedure

[bartvb]

Is it possible that you can only have one parameter in a stored procedure you whish to call from crystal reports??

Because test2 is selectable from the stored procedures and test is NOT ??

Thanx, Bart

**************************************************
PROCEDURE TEST2 (QUERY OUT REFTYPE, PARAM1 IN CHAR)
IS
BEGIN

OPEN QUERY FOR SELECT AS_CODE, AS_OMSCHRIJVING
FROM ACTISTAT
WHERE UPPER(AS_CODE) LIKE UPPER(PARAM1) || '%';

END TEST2;
***************************************************
PROCEDURE TEST (QUERY OUT REFTYPE, PARAM1 IN CHAR, PARAM2 IN CHAR)
IS
BEGIN

OPEN QUERY FOR SELECT AS_CODE, AS_OMSCHRIJVING
FROM ACTISTAT
WHERE UPPER(AS_CODE) LIKE UPPER(PARAM1) || '%'
AND UPPER(AS_CODE_OUD) LIKE UPPER(PARAM2) || '%';

END TEST;