Thanks for the reply, Arun. That doesn't seem to fix it. Perhaps my syntax is wrong. Here's what I have :
P1: BEGIN
DECLARE cursor1 CURSOR WITH RETURN FOR
IF pSTREET_TYPE = '' THEN
Select * from SW.ADDR_VERIFICATION
where QUADRANT = pQUAD
and STREET = pSTREET...
Thanks for the reply Marc.
oops. I forgot to put the begin and end back in. When the BEGIN and END are around the outside of the if statement, I get an error on the second cursor delcaration "Unexpected Cursor Declaration"
I have also tried putting a BEGIN and END around the SQL...
I'm looking over something stupid here. Can someone tell me how to do an if statement that will do the following. I think this is close, but it's not working. Both sql statements work independently. Something crazy that I'm doing with the IF and definition of cursors I think:
CREATE...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.