ORA-01001 Invalid cursor

I have a reference cursor used in a stored procedure...with the record type defined in a package spec. The package & package body (where the procedure is located) compiles fine. However, my front-end application is giving me an "invalid cursor" error.

I've successfully executed stored procedures returning reference cursors in the past; however, this cursor has 121 columns...the SELECT statement is 7989 characters long.

The Oracle documentation says that it may be necessary to increase AREASIZE; however, another portion of the documentation says that this parameter is obsolete in version 7.0. I would not know where to increase this parameter anyway (or MAXOPENCURSORS).

Any other ideas of what the problem might be?

Thanks,

--
Brian in Seattle
Pride, commitment, teamwork - words we use to get you
to work for free.

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own