i am using a view query in oracle.if i am run the query successfully executed.but,the same query applying in asp page(front end)it's showing ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table.
please help...
3 6110
Please post the underlying SQL of the view with structure of all the base tables for further analysis.
- select v4.JOBREFNO AS INV, V1.ORIGIN_FV_PRQ,V1.PDFNAME_PRQ,V1.COUNTRY, V1.VESSELNAME_FV_PRQ, V1.VOYAGENO_FV_PRQ, to_char(V1.ETD_FV,'dd-Mon-YYYY') as ETD_FV, to_char(V1.ETA_FV_PRQ,'dd-Mon-YYYY') as ETA_FV_PRQ, V1.ORIGIN_PRQ, V1.SHIPPER_PRQ, V1.BILLTO_PRQ,V1.BILLTOPREPAID_PRQ, V1.POID_PRQ, V1.STYLE_PRQ, V1.MVSNO_PRQ,V1.VESSELNAME_PRQ, V1.VOYAGENO_PRQ, V1.HBL_PRQ, V1.JOBREFNO_PRQ, to_char(V1.JOBDATE_JOB,'dd-Mon-YYYY') as JOBDATE_JOB, V1.SUPPLIERINVNO_PRQ, V1.SUPPLIERINVNO_PRQ, V1.POCONTAINER_PRQ, V1.CSIZE_PRQ, V1.SEAL_PRQ, to_char(V1.ETD_PRQ,'dd-Mon-YYYY') as ETD_PRQ , to_char(V1.ETA_PRQ,'dd-Mon-YYYY') as ETA_PRQ , V1.POA_PRQ, V1.CCTNS_PRQ,V1.NOP_PRQ, V1.QTY_PRQ, V1.CONSIGNEENAME_PRQ, V1.POSTYLEGW_PRQ, V1.POSTYLECUBE_PRQ, V1.POA_FV_PRQ,V1.CSTATUS,v2.COLLFROM,v2.PORT,v2.DEL_ADDRESS,v2.BOOKEDBY,to_char(v2.BOOKEDON,'dd-Mon-YYYY') as BOOKEDON,v2.CONSIGNEEBOOKINGREF,to_char(v2.CONSIGNEEBOOKINGDATE,'dd-Mon-YYYY') as CONSIGNEEBOOKINGDATE,v2.BOOKEDBY,to_char(v2.DELIVERYDATE,'dd-Mon-YYYY') as DELIVERYDATE ,v2.PODSIGNEDBY,v2.REMARKS from ETRANS3103.SEA_IMPORTS_PRQJOB_NEW@etrans1_link v1 left join etrans3103.SEA_GENERIC_DELIVERY_VIEW_BD@etrans1_link v2 on V1.JOBREFNO_PRQ=v2.JOBREFNO and V1.POCONTAINER_PRQ=v2.CONTAINERNO LEFT JOIN etrans3103.INVOICE_CHECK_SEA@etrans1_link v4 on V1.JOBREFNO_PRQ=v4.JOBREFNO where (CONSIGNEEID_PRQ in ('LONSTAT8354','LONGE H11979','LONSTAT8549','LONGE H13089','LONGE H14470','LONGE H18495','LONGENO6219','LONGELI5022','LONGE L10465','LONGE L10464','LONGE N1530','LONGE H40459' ) or BILLTOPREPAID_PRQ in ('GE HUNGARY LIMITED','GE HUNGARY. RT.','GE HUNGARY. RT.','GE LIGHTING LIMITED - LEICESTER','GE LIGHTING LIMITED- ENFIELD','GE LIGHTING LTD - NORTHAMPTON','GE LIGHTING OPERATIONS LIMITED - NORTHAMPTON','GE LIGHTING SALES AND MKTG LEICS','GE HUNGARY LIMITED','GE LIGHTING LIMITED- ENFIELD') or BILLTOCOLLECT_PRQ in ('GE HUNGARY LIMITED','GE HUNGARY. RT.','GE HUNGARY. RT.','GE LIGHTING LIMITED - LEICESTER','GE LIGHTING LIMITED- ENFIELD','GE LIGHTING LTD - NORTHAMPTON','GE LIGHTING OPERATIONS LIMITED - NORTHAMPTON','GE LIGHTING SALES AND MKTG LEICS','GE HUNGARY LIMITED','GE LIGHTING LIMITED- ENFIELD')) and (V1.ETA_PRQ between '01-Jul-2011' and '02-Aug-2012') order by ETA_PRQ DESC , v1.HBL_PRQ asc, v1.QTY_PRQ desc
here,inside of query using more view..
this query executed in toad ,but front end page(asp) showing error message.
Try to create a materialized view with BUILD IMMEDIATE by using the Underlying SQL.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Galina |
last post by:
Hello
I have created a trigger not to let records with certain fields null
to be inserted into the table:
BEGIN
IF :new.RUL_CODE is null or
:new.FES_UINS_CODE is null or
:new.FES_UIO_CALOCC is...
|
by: John |
last post by:
Hi
Right password -> ORA-12154: TNS:Could not resolve service name
wrong password => ORA-01017: invalid username/password; logon denied
Tested on a Windows XP client connecting to Oracle on...
|
by: bdj |
last post by:
Hello!
I have at set of tnsnames.ora. I wich to make an union, e.g. a single file
of it.
How can I do that easy?
Greetings
Bjørn
|
by: DavidTurcotte |
last post by:
Hi
I have been working on this bugs for the last 2 days and i am out of
gas.
i have a ORA-12154: TNS:could not resolve service name error message
when i try to acces an Oracle database
The...
|
by: mpatel6 |
last post by:
I had this error in alert log and my instance was down, anybody can help me?
Errors in file /u01/app/oracle/admin/sotstest/bdump/sotstest_p004_626740.trc:
ORA-07445: exception encountered: core...
|
by: Dwie |
last post by:
Dear All,
I'm a new in Oracle DB. I'm using Windows 2000 as server and Windows XP as client. I installed Oracle Enterprise on server and Oracle 8.1 on clients.
I have some client with 2 different...
|
by: nabh4u |
last post by:
HI everyone,
I an getting the following errors when i execute my procedure.
SQL> exec PROCEDURE_NAME
BEGIN PROCEDURE_NAME; END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error:...
|
by: basmgokul |
last post by:
I am using oracle 10g in windows vista..
when starting DB it throws an error
Errors in file c:\database\udump\practice_ora_440.trc:
ORA-00704: bootstrap process failure
ORA-39700: database...
|
by: michael ngong |
last post by:
michael.john@gmx.at (Michael John) wrote in message news:<90cc4edd.0306230900.28075193@posting.google.com>...
MIchael
I you stated the OS and platform that could make it easier to address your...
|
by: hoonig |
last post by:
I have this traditional error "ORA-12560:TNS:Protocol Adapter Error"
when trying to connect to my Oracle 8i databases on Netware (i.e when
i load svrmgr31, plus81, etc...)
Listener seems to work...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| | |