procedure runs under 10.2, but not under 11.2
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",