The STATIC option basically does exactly what you described as "your own cursor": it makes a copy of the cursor definition in tempdb

The set based solution we're talking about would be a replacement of the API_proc.

In order to help you further we'd need to know what that proc does.