Christian,

I tried to close prepared statement and got this exception:

[BXSQ0002] No opened connection with id 1

It throws exception at line

let $clres := sql:close($prep)


 let $prep := sql:prepare($conn,$sqlStmt)
    let $params := <sql:parameters>
                     <sql:parameter type='string'>{$useType}</sql:parameter>
                   </sql:parameters>
    let $result := sql:execute-prepared($prep, $params)
    let $clres := sql:close($prep)




On Wed, May 28, 2014 at 3:51 PM, Christian Grün <christian.gruen@gmail.com> wrote:
> sql:close is for connection to SQL server but prepared statement?

If I remember right, it's for both. Did you have a try?