lp_update_tkt_hist customization

Sounds to me like there might be a mismatch between the fields/variables specified in the select statement and the fields/variables listed in the INTO statement in the procedure.??

Penny Tabor

IT Manager

Midland Center for the Arts

Midland, MI 48640

Hello all,

When we converted in January, we had our ticket history table (lt_tkt_hist) customized per our marketing department for list building purposes.  For conversion purposes, all worked out well.  However, we're at the point where we need to get the nightly procedure for updating this table configured.  However, I'm stumped by the error i'm continually getting.  It reads: "Cursorfetch: The number of variables declared in the INTO list must match that of selected columns."

I don't suppose there is someone out there that knows how to correct this error.  I've gone to about the limits of what I can do and comtemplated rewriting the whole SP from scratch, but would rather not reinvent the wheel.  Anyone got ideas what I should be looking for int his SP to correct the error?

Thanks!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Sounds to me like there might be a mismatch between the fields/variables specified in the select statement and the fields/variables listed in the INTO statement in the procedure.??

Penny Tabor

IT Manager

Midland Center for the Arts

Midland, MI 48640

Hello all,

When we converted in January, we had our ticket history table (lt_tkt_hist) customized per our marketing department for list building purposes.  For conversion purposes, all worked out well.  However, we're at the point where we need to get the nightly procedure for updating this table configured.  However, I'm stumped by the error i'm continually getting.  It reads: "Cursorfetch: The number of variables declared in the INTO list must match that of selected columns."

I don't suppose there is someone out there that knows how to correct this error.  I've gone to about the limits of what I can do and comtemplated rewriting the whole SP from scratch, but would rather not reinvent the wheel.  Anyone got ideas what I should be looking for int his SP to correct the error?

Thanks!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!