Database Administration (MOSC)

MOSC Banner

procedure runs under 10.2, but not under 11.2

edited Oct 16, 2012 11:41AM in Database Administration (MOSC) 13 commentsAnswered
Hi all.

We have a vendor's package that is currently running under oracle version 10.2. I have been trying to migrate it to 11.2.0.3 and one procedure won't compile. I have found a part of that procedure which give me different output when executed under v10 and v11. Here is that part

CREATE PROCEDURE
(

    MID    IN INT,
    LID      IN INT,
    QRevision IN INT,
    Lang       IN VARCHAR2,
    Base       IN INT,
    Questions Out ST_PKG.RECORDS
)

  < removed some code >

            SELECT q.Question_MID "Question_MID",
            q.Question_LID "Question_LID",
            q.Revision "Revision",
            q.Topic_ID "Topic_ID",
      Dlv_Getreportedtopicfullpath(tp.Topic_ID, tp.lang) "Topic_Name",

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center