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  5899 
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: Kemmylinns12 |
last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
|
by: Naresh1 |
last post by:
What is WebLogic Admin Training?
WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
|
by: antdb |
last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine
In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
|
by: Matthew3360 |
last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function.
Here is my code.
header("Location:".$urlback);
Is this the right layout the...
|
by: AndyPSV |
last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...
|
by: Arjunsri |
last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
|
by: Matthew3360 |
last post by:
Hi,
I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
|
by: Oralloy |
last post by:
Hello Folks,
I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA.
My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
|
by: Rahul1995seven |
last post by:
Introduction:
In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
| | |
