Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467

    Unanswered: ORA-22806: not an object or REF

    Setup: Forms 9i, 9iDB

    I am getting a "ORA-22806: not an object or REF" error on this query.

    SELECT ROWID,Value,MR_PARAMETER_ID,PARAMETER_ID,MASTER_RE CIPE_ID,RECIPE_REVISION,HI_LIMIT,LO_LIMIT FROM MDM_MR_PARAMETERS WHERE (MASTER_RECIPE_ID=:1) and (RECIPE_REVISION=:2) order by (SELECT NVL(EDITABLE , 'N') FROM MDM_PARAMETER_ATTRIBUTES WHERE PARAMETER_ID = :MDM_MR_PARAMETERS.PARAMETER_ID) DESC

    The "order by" clause is included because I have used a SET_BLOCK_PROPERTY(..., ORDER_BY, ...). Can any one give me some insight on what an object or REF is?
    NOTE: Please disregard the label "Senior Member".

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    Todd, is there an error in your ORDER BY clause?

    Code:
    PARAMETER_ID = :MDM_MR_PARAMETERS.PARAMETER_ID)
    I don't believe the colon should be there... I wonder if Oracle is trying to dereference an object because of the bind variable notation. If that is the case, I would venture a guess that you are receving an error based on the non-existant object.

    JoeB

  3. #3
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    You are correct. I removed the : and the query worked.

    I was basing my structure on the DEFAULT_WHERE form. Looking at the ORDER_BY description again I see that it does not even mention that you can use form parameters etc. I guess it is a good thing I did not read it closely the first time. :-)

    Thanks again brother.
    NOTE: Please disregard the label "Senior Member".

Posting Permissions

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