Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Package compilation error

Re: Package compilation error

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 25 Feb 2004 21:34:43 +0100
Message-ID: <c1j0q8$pj1$1@news4.tilbu1.nb.home.nl>

Onder Kaya wrote:

> Hello everyone,
>
> We are trying the compile this package but we get this error.
>
> PACKAGE BODY APPS.XNC_BOM_PVT
> On line:32
> PLS-00358:'ASSEMBLY_ITEM_ID' exists in more than one table, use qualifier
>
> What should we do to solve this
>
> I appreciate
> Thanks

Edit package body, line 32, and use a table qualifier. E.g. :
select e.dept_no, dept_name
from employees e, departments d
where e.dept_no = d.dept_no;

dept_no would exist in both the departments and employees tables. The "e" would be an alias, used as qualifier; an other way to write it would be:
select employees.dept_no, dept_name
from employees, departments
where employees.dept_no = departments.dept_no;

dept_name does not need one, as the column is unique within the above query: it only exists in departments, so no further qualification is needed

-- 

Regards,
Frank van Bortel
Received on Wed Feb 25 2004 - 14:34:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US