GuardianOfTheFlame
Programmer
Hi all,
how can I create a cursor for a SELECT statement previously prepared?
I must do something like this:
DECLARE cur CURSOR
FOR SELECT * FROM <tab> WHERE Id=<id>;
<tab> and <id> are parameters passed to my stored procedure.
Can I prepare the SELECT statement and then assign it to the cursor AFTER the declaration?
Thanks,
Salo
---
The surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us - Calvin (and Hobbes) ;-)
how can I create a cursor for a SELECT statement previously prepared?
I must do something like this:
DECLARE cur CURSOR
FOR SELECT * FROM <tab> WHERE Id=<id>;
<tab> and <id> are parameters passed to my stored procedure.
Can I prepare the SELECT statement and then assign it to the cursor AFTER the declaration?
Thanks,
Salo
---
The surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us - Calvin (and Hobbes) ;-)