Oracle Forms

Hi,

DB running on : 9i
Forms version : 6

I had two existing forms which had the same block name and exactly same items field. On the block it contains 5 database items and 5 which is not.

This sql statement is attach on the database data block where clause

1 = 0
union all
select rscn.rowid, rscn.buni_code, rscn.rcol_id, rscn.cpn_no, rscn.sts, rscn.inln_id
from mss_rms_cpn rscn,
mss_rms_cpn_order_lines rcol,
mss_rms_cpn_orders rsco


This two forms run in a different suite or scheme but one of them work and one doesn't work and give me that ORA-01789: query block has incorrect number of result columns. I checked the database table they do have all the fields and I also checked all the database items with in that data block had exactly the same
name as from the table and all were Yes to Database Items.

The only thing I can think of the problem is the rscn.rowid which causing the problem. I think there must be missing something such as setup need in order allow
the rowid to be use?

regards,

david