Announcement

Collapse
No announcement yet.

Select bug

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Select bug

    Hi there, is this a bug/problem?
    http://postimg.org/image/s6n4zr1kr/
    Last edited by Clauu; 02-24-2014, 06:53 AM.

  • #2
    The Oracle docs note this on the ora-00918 error*:

    ORA-00918 column ambiguously defined

    Cause: A column name used in a join exists in more than one table and is thus referenced ambiguously. In a join, any column name that occurs in more than one of the tables must be prefixed by its table name when referenced. The column should be referenced as TABLE.COLUMN or TABLE_ALIAS.COLUMN. For example, if tables EMP and DEPT are being joined and both contain the column DEPTNO, then all references to DEPTNO should be prefixed with the table name, as in EMP.DEPTNO or E.DEPTNO.

    Action: Prefix references to column names that exist in multiple tables with either the table name or a table alias and a period (.), as in the examples above.

    When ORA-00918 is thrown, you have a column which has been ambiguously defined. If a column name in a join is referenced ambiguously, it exists in multiple tables.
    • Column names which occur in multiple tables should be prefixed when it is referenced by its table name.
    • Columns must be referenced as TABLE.COLUMN or TABLE_ALIAS.COLUM . Oracle documentation which reference ORA-00918 give the following example: - If tables EMP and DEPT are being joined and both contain the column DEPTNO, then all references to DEPTNO should be prefixed with the table name, as in EMP.DEPTNO or E.DEPTNO.
    To correct ORA-00918, references should be prefixed to column names existing in multiple tables (either with the table name or table alias and a period)
    ORA-00918 column ambiguously defined

    Cause: A column name used in a join exists in more than one table and is thus referenced ambiguously. In a join, any column name that occurs in more than one of the tables must be prefixed by its table name when referenced. The column should be referenced as TABLE.COLUMN or TABLE_ALIAS.COLUMN. For example, if tables EMP and DEPT are being joined and both contain the column DEPTNO, then all references to DEPTNO should be prefixed with the table name, as in EMP.DEPTNO or E.DEPTNO.

    Action: Prefix references to column names that exist in multiple tables with either the table name or a table alias and a period (.), as in the examples above.



    source: http://www.dba-oracle.com/t_ora_0091...ly_defined.htm
    Best Regards,
    John L. Santos

    Bug Tracker Team
    NetMake - IT Solutions

    Comment


    • #3
      Yes i know that, i have to prefix every field or all with prefix.* but i posted here since i don't know if scriptcase should remember old fileds since i have selected everything or maybe this is normal due to some internal checks like rows etc

      Comment


      • #4
        We had similar behaviour that caused strange things to happen. Oddly enough removing the links regenerating and restoring the links made it work properly again. Apparently there is somehow a bug in sc that cant be clearly determined.

        Comment

        Working...
        X