By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,502 Members | 1,878 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,502 IT Pros & Developers. It's quick & easy.

Package compilation error

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.