Prepared Statements inside stored procedures

[Bart Pietercil]

Hi List,

just wondering if it is possible to use prepared statements inside stored procedures.
If not, why not (= feature request)

Certainly when looping over a cursor and using the cursor for building new queries, the speed of execution would rise because the prepared statement would be recognized by the parser and could be picked up (from the second pass on) from the query pool ?

Or am I misunderstanding ?

tia


Bart Pietercil
CTO Cognosis NV