Extension utilization in query.

[Former Member]

Hi Experts,

I have written a query, using extension created in "project type".

SELECT <%RESULTS%> FROM <%SCHEMA%>.FCI_PRO_TYPE T1, <%EXT_TABLE(projects.ProjectType)%> E1 WHERE CONTEXTID=<%CONTEXT(projects.ProjectType)%> AND T1.OBJECTID=E1.PARENT_OBJECT_ID <%ORDERBY%>

When i execute it.:

SELECT OBJECTID, 1107 AS CLASSID, DISPLAY_NAME, CREATED_BY_USER_OBJECT_NAME, LEVEL1APPROVER FROM eservice.FCI_PRO_TYPE T1, eservice.FCI_DYN_$2147483448 E1 WHERE CONTEXTID=-2147483546 AND T1.OBJECTID=E1.PARENT_OBJECT_ID ORDER BY 3

SQL Exception: ORA-00918: column ambiguously defined , ANSI-92 SQL State: 42000, Vendor Error Code: 918. ORA-00918: column ambiguously defined

the Database_column_name is "LEVEL1APPROVER" in the extension schema. can you pls tel me where my error is!!.

Thanks,

Shikha

Edited by: thakur_shikha on Aug 2, 2011 8:26 AM

[Former Member · Accepted solution]

Hi,

In the posted query, CONTEXTID=-2147483546 needs to have an alias, like T1.CONTEXTID.

Regards,

Simion

[Former Member · Accepted solution]

Hi Simion,

Thanks for the reply!!..

The issue got solved.

the query that worked is:

SELECT <%RESULTS%> FROM <%SCHEMA%>.FCI_PRO_TYPE T1, <%EXT_TABLE(projects.ProjectType)%> T2 WHERE T1.CONTEXTID=<%CONTEXT(projects.ProjectType)%> AND T1.OBJECTID=T2.PARENT_OBJECT_ID

Thanks,

Shikha.

Edited by: thakur_shikha on Aug 3, 2011 7:48 AM