Declaring Two cursors in a stored procedure

[balachandar]

Hi All,
I am just trying to build a procedure with two cursors. Depending on the parameter passed either one of them will be opened. This is the code I have written. I am not able to compile it. Please let me know how I can do it correctly.
I mean the question is how can declare two cursors in a program and open only one conditionally.
Balachandar Ganesan.

 

[MarcLodge]

You should be able to examine the parameter passed and then progamatically branch to the specific cursor required. There should not be any problem with doing this. To help you further I think I may need to know operating system, language etc.

Marc

 

[gregsimpson]

Balachandar,

please post your code and we may be able to help you.


Cheers
Greg