Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    3

    Question Unanswered: Oracle and Classic ASP Error

    I have a bit of a strange issue and I can't quite figure it. The SQL I've written executes properly in SQL*Plus, but won't run across a connection to the Oracle Database. All it does is come back with the following error:

    -------------------------------------------------------------------
    OraOLEDB error '80040e14'

    ORA-00904: : invaild identifier

    /prismoc/scripts/MTP/ASP/Update-step-4.asp, line 95
    -------------------------------------------------------------------

    Line 95 of the file
    -------------------------------------------------------------------
    conn.execute "UPDATE TS2D.MTP_Stage_0 SET Programme_Start_Date = TS2D.Fetch_MTP_Year(Programme_Start_Year)"
    -------------------------------------------------------------------

    TS2D is the Schema
    Fetch_MTP_Year is just a UDF within the schema.
    -------------------------------------------------------------------
    Function Fetch_MTP_Year (cDate In Date)
    Return Number
    IS
    cYear Number(4);
    Cursor C1 is
    SELECT Year FROM MTP_Dates WHERE StartDate <= cDate AND FinishDate >= cDate;
    Begin
    Open C1;
    Fetch C1 INTO cYear;
    Close C1;
    Return cYear;
    End;
    -------------------------------------------------------------------

  2. #2
    Join Date
    Dec 2010
    Posts
    3
    Mystery solved, but thought I would admit my stupidity ... I had forgotten to grant execute permission for the connection to the UDF.

Posting Permissions

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