I have a a map who works allright with embedded SQL. "Select Once For Retrieval" in a rule and then "Fetch After Prior Select" in the next step.
I want to switch to stored procedure call in ASE. The correct way to do it seems to change "Select Once For Retrieval" to "Stored Procedure Call" and change "Fetch After Prior Select" to "Fetch After Procedure Call".
When i do this ECMap hangs when I run the map and ODBC-tracing will show why. The procedure get called in an infinite loop.
Do sombody know why this happens?
I want to switch to stored procedure call in ASE. The correct way to do it seems to change "Select Once For Retrieval" to "Stored Procedure Call" and change "Fetch After Prior Select" to "Fetch After Procedure Call".
When i do this ECMap hangs when I run the map and ODBC-tracing will show why. The procedure get called in an infinite loop.
Do sombody know why this happens?