Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Location
    Philadelphia
    Posts
    8

    Angry Unanswered: ORA-24338: statement handle not executed

    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.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: ORA-24338: statement handle not executed

    Originally posted by cavada1
    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?

  3. #3
    Join Date
    Oct 2003
    Location
    Philadelphia
    Posts
    8
    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.

  4. #4
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    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.
    Edwin van Hattem
    OCP DBA / System analyst

  5. #5
    Join Date
    Oct 2003
    Location
    Philadelphia
    Posts
    8

    ORA-24338: statement handle not executed

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •