possible: call stored procedure without cursor

Is it possible to call a stored procedure without a cursor?

What DBMS are you using? In PostgreSQL, which handles procedures quite normally, I regularly create procedures without worrying about cursors. As far as I know, the two are indepent of each other.

Why do you ask? Were you trying something that didn't work?

Hi rycamor, thanks for the reply.

I'm using MSsql and this is one of those situations where I just don't think (well at least my current knowledge) you can avoid using a cursor to call the stored procedure.

It's not an error or anything, I just prefer to avoid using cursors and use them as only last resort and was wondering if there was a quicker way of calling a stored procedure within mssql2000 without using cursors...

It's nothing urgent seeing as how it's a batch job once a day but I still like to keep it small and just figured there has to be a way to call a SP without cursors, so if you know how to do this in MSsql that would be most helpful.

It depends on what kind of cursor you are thinking of, and what your host language is.

Try EXEC mystoredproc