I have an ASP page calling a package and I'm getting the above error.
The code for my proc is:


Procedure DS_GRANT_ACCESS (C_DISPLAY OUT t_cursor, v_ntid IN varchar2)

IS v_cursor t_cursor;

BEGIN

OPEN v_cursor FOR
SELECT (cols)
FROM Table;

END DS_GRANT_ACCESS;

I'm getting the error on the ExecuteReader(), it works from SQL+

Any ideas would be appreciated.

What EXACTLY "works from SQL+"?
Is the above "code" really what is in Oracle?
Why in the world is "v_ntid" passed as an input argument?
What does it do?

When I execute the proc from with in Oracle it runs fine.

The code is just the the basic structure of the proc and SQL.

v_ntid is a param in the WHERE clause (which I accidentally left out)

The real proc returns a person's NT ID from a table for use use the page.

hi,

this is what metalink says about ur problem :

Error: ORA-24338
Text: statement handle not executed
---------------------------------------------------------------------------
Cause: A fetch was attempted before executing a statement handle. Action: Execute a statement and then fetch the data.

AND


If you try to fetch from a cursor which is not open, you get an error
"ORA-01001: invalid cursor".

If you encounter the error "ORA-24338: statement handle not executed" the reason may be that, "Fetch Size Buffer" parameter set on the DSN on the Oracle ODBC Driver Configuration panel is not configured properly.

Increase the size of the the Size Buffer parameter of the DSN on Oracle ODBC
Driver Configuration panel to 128000 bytes.

hope this helps.

Even if I'm using Microsoft's .net provider for Oracle?