How do I declare a cursor in a stored procedure if that cursor contains a WHERE which depends on the argument given to that stored procedure? I can't get passed this message: 'Cannot mix placeholder styles "$1" and ":foo"' The message doesn't give a useful line number, so I don't even know which line it's complaining about. -Nigel ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
