Sterling Map Editor

[yanseiler]

Hi,

I wrote an Oracle function which returns a ref cursor in order to use it in the Map Editor instead of a query.

When I use it in the Map Editor it can retrieve the fields but when it is used within the translator in Sterling Commerce I get an error message like "no data returned".

I put that in the query section:
pckedi.getNotSentOrderHeadersSwatch

And i have checked the following options:
- it returns a resutlset
- this is a stored procedure

It is working fine within SQL*PLUS:
SQL> var c1 refcursor
SQL> exec :c1 := pckedi.getNotSentOrderHeadersSwatch
PL/SQL procedure successfully completed.

SQL> print c1

ID ORDERNAME IS CLIENTNUMBER DATEOFOR TIMEOF
---------- ---------- -- -------------------------------- -------- ------
REQUESTE
--------
2759 STERLING2 AZ 6039 20040224 122802
20040126

2760 STERLING GE 6038 20040224 122802
20040128

2761 STERLING3 SI 116101 20040224 122802
20040217


Does someone have an idea