Oracle ORA-19025: EXTRACTVALUE returns value of only one node - using webservice

HiI have made a simple webservice that returns cityID and CityName using Jdeveloper 10.1.3.3.0I have implemented it in my Apex application using Application Express 3.0.1.00.07. The service function ok when testing it using the BPEL Control and when testing it in Apex from the shared Components, web ...

Oracle "ORA-19025 EXTRACTVALUE returns value of only one node" - Suggestion

ORA-19025 EXTRACTVALUE returns value of only one node When this error occurs, would you please provide some or all of the following information:(1) row number(2) row id(3) the name of the offending column(5) the XQuery expression(6) the node name(7) the text value being parsed, in which an excess no ...

Oracle ORA-19025: Extractvalue returns the value of only one node

I am trying to extract the data from an xmltype table where there is possibility of just one node. I am running into ORA-19025 error when there is only one node. Can someone please help me to handle this error when I come across only one node.Here is my sql: SELECTT_ID,EXTRACTVALUE(value(input_data_ ...

Oracle ORA-19025

Taken from Oracle documentation the following:<PurchaseOrder><Reference>ADAMS-20011127121040988PST</Reference><Actions><Action><User>SCOTT</User><Date>2002-03-31</Date></Action></Actions><Reject/><Requestor>Julie P. Adams ...

Oracle Error Messages : ORA - 37118, ORA - 06512

When i'm starting the oracle workspace manager software and trying to create a new workspace related to a schema, after to be connected to a database instance,I get those error messages: ora - 37118, ora - 06512 ...

Oracle ORA-20006: ORA-01722: invalid number ORA-06512: at "APPS.WF_NOTIFICATION"

I am having a wft program, which checks a function activity and depending on the value returned sends difference notifications.The package body completed successfully from backend and while running the workflow program it sends a notification also. But while opening the notification it gives the fol ...

Oracle I met ORA-00935 group function is nested too deeply Message.

I made a table like below,==============================CREATE TABLE ser_1m_det (time TIMESTAMP,proto NUMBER(3,0),port NUMBER(5,0),pkts NUMBER(17,0),vol_m NUMBER(17,4));====================================Then I want to use below SQL====================================SELECT proto, port, SUM(pkts) p ...

Oracle ORA-06502 ORA-06512 on upgrade to 10g from 9i

When the database was upgraded to 10gR2 from 9i a customer is getting ORA-06502 ORA-06512 errors. It happens for Oracle Apps installationThey have removed the database initialization parameter "_optimizer_cost_model" as per the Oracle Apps standards. But when they reintroduce it and assign as "io", ...

Oracle ACL connect privileges ORA-01422 ORA-06512

Application Express Installation Guide3.3.6.1 Granting Connect PrivilegesThe following example demonstrates how to grant connect privileges to any host for the APEX_030200 database user.DECLAREACL_PATH VARCHAR2(4000);ACL_ID RAW(16);BEGIN-- Look for the ACL currently assigned to '*' and give APEX_030 ...

Oracle Error ORA-24344/ORA-06512 on PL/SQL Trigger creation

got a strange problem here.The following script execute perfectlyCREATE OR REPLACE TRIGGER VersionInsertTrigger BEFORE INSERT ON Version FOR EACH ROW BEGIN SELECT VersionSequence.nextval INTO :new.Idx FROM dual;SELECT UID INTO :new.UserIdent FROM dual;SELECT UPPER(:new.Entity) INTO :new.Entity FROM ...

Oracle ora:29855-ora:13203 spatial

hii have a problem with the spatial index.i have the next codemy table isCREATE TABLE MBTE_BLQ_BLOCK(BL_ID NUMBER NOT NULL,BLM_ID NUMBER,BL_COORX NUMBER(10,3) NOT NULL,BL_COORY NUMBER(10,3) NOT NULL,BL_COORZ NUMBER(10,3) NOT NULL,BL_HASDATA NUMBER(1))/* función obtener geometria dado un punto*/cr ...

Oracle UTL_FILE error? - ORA-20001: ORA-0000: normal, successful completion

I wrote a procedure and am getting the following error message about 20 minutes into the processing:*ERROR at line 1:ORA-20001: ORA-0000: normal, successful completionORA-06512: at "APPHARRIS.P_HARRIS_BULK_COLLECT", line 502ORA-06512: at line 1I have a fairly large amount of data that gets processed ...

Oracle ORA-20100: ORA-01116: error in opening database file

I'm hitting this error for the first time. Anyone encountered this before? Any suggestions will be very appreciated. Thanks!141 EXCEPTION142 143 when others then144 raise_application_error('-20100',SQLERRM);145 End;146 /2008020720080312Declare*ERROR at line 1:ORA-20100: ORA-01116: error in opening d ...

Oracle ORA-00604 ORA-01401 occur when comment on column

when i add comments on some columns, ORA-00604 ORA-01401 occurhow to deal?comment on column zxinsag.sag_mms_downrequest.needreceipt is '????' ORA-00604: error occurred at recursive SQL level 1ORA-01401: inserted value too large for columnORA-06512: at line 2 ...

-2147217873 ora-01110 ora-01578

i have the the following err msg while updating a remote database..-2147217873 ....ora-01110...ora-01578..from the oracel err msg, it seems the block is corruptted..not really understand wat is this...i am using VB6 ADODB recordset with .Addnew and .update to create a new record.... ...

Ora-01034/ora-27101

I'm getting these two Oracle Error messages while I try to login to sqlplus using any login. I've tried all the steps from this thread:Ora-01034 / Ora-27101except when I got to this point:SET ORACLE_SID=ilnksqlplus /nologconn sys/change_on_install as sysdbastartupI received an error 'ORA-01031: insu ...

Oracle ORA-29902 / ORA-01455 on thesaurus search

i have a problem with the intermedia thesaurs search.When i use a thesaurus function in my querySELECT rowid FROM wag_vlb_storage WHERE CONTAINS(xml, 'pt( Kinder) within title') > 0 AND storage_type='PRD'an oracle error ORA-29902 / ORA-01455 occurs.My thesaurus have 470.000 term (TT) (2.5 Mill al ...

Oracle ORA-29902 / ORA-01455 on thesaurus search

repost Hi, i have a problem with the intermedia thesaurs search. When i use a thesaurus function in my query SELECT rowid FROM wag_vlb_storage WHERE CONTAINS(xml, 'pt( Kinder) within title') > 0 AND storage_type='PRD' an oracle error ORA-29902 / ORA-01455 occurs. My thesaurus have 470.000 term (T ...

Oracle ORA-29902 / ORA-01455 on thesaurus search

repost - anybody from the intermedia team out there ??? Hi, i have a problem with the intermedia thesaurs search. When i use a thesaurus function in my query SELECT rowid FROM wag_vlb_storage WHERE CONTAINS(xml, 'pt( Kinder) within title') > 0 AND storage_type='PRD' an oracle error ORA-29902 / OR ...

Oracle Why there are 2 tnsnames.ora & listener.ora files ?

According to the installation guide, I have TNS_ADMIN=/opt/oracle/config/9.2.0; export TNS_ADMINin the .profile at home directory of user "oracle"After installation succeeded, I found that there are two places that have tnsnames.ora & listener.oraOne is at /opt/oracle/config/9.2.0Other one is at ...

Oracle SQL Loader and Error ORA-01847/ORA-01839

While using the direct loading in SQL-LOADER when we get the ORA-01847/ORA-01839 all the other records are getting errorred out. It goes fine with the conventional loading. Should I use some parameters or anything to make sure that all the other records are not rejected when we get the ORA-01847/ORA ...

Oracle return ORA-02019,ORA-02063 during update view base on DB Link

I created simple application base on view. When I try to update something I get ORA-02019,ORA-02063. Same update from SqlPlus works as expected. Help me, Stanislav. ...

Oracle ORA-01652, ORA-27056, OSD-04005, O/S Error

I'm using the following querySELECT O.TRAIN_NO_C, O.OUT_DATE_D, OD.COACH_NO_C, C.CLASS_CODE_C, C.AC_NAC_TYPE_C, R.LAST_DEALT_DATE_D FROM MECD_PF_OUTTRN_T O, MECD_PF_OUTTRN_DTL2_T OD, MECD_PL_RS19_DTL1_T R, MECD_COACH_M C, MECD_TRAIN_M T WHERE O.TRAIN_NO_C = T.OUT_TRAIN_NO_C AND O.OUT_DATE_D + T.INTD ...

Oracle ORA-01034 & ORA-27101

I have oracle running on Redhat linux. It was working fine previously and I had to change the IP address to roll it into production.I have changed tnsnames.ora, listener.ora, snmp_ro.ora and sqlnet.ora files to new IP address.Now, I get ORA-01034 error, saying that Oracle is not available. And somet ...

Oracle where should i keep listener.ora, tnsnames.ora files in 10g R2 RAC ?

Created 3 separate homes for Oracle CRS, Oracle ASM and Oracle instance1 under Oracle 10g R2 RAC setup. where should i keep listener.ora, tnsnames.ora & init.ora files? should i keep them in ASM home or Oracle instance1 home directory? ...

Oracle 10g I don't have the files listener.ora, tnsnames.ora and sql.ora

I uninstalled my Oracle 10g and when I re installed I got success, but when I went to the folder \network\admin didn't have the files listener.ora, tnsnames.ora and sql.ora. I have been trying during more than one month start my listener only because I need access the Oracle database from my Java ap ...

Oracle urgent ora -00353 ora-354 ora-312 errors

we are getting following errors on one of our databasei found the following on metalink to resolve TIP: Click help for a detailed explanation of this page. Bookmark Go to End Subject: Ora-354 Ora-353 And Ora-312 Reported On Mirrored Redo Log Files Doc ID: Note:332672.1 Type: PROBLEM Last Revision Da ...

Oracle ERROR: ORA-20999: ORA--20999 Error Number Not Defined

I'm not sure if it ok to post this error message here, let me know. I've searched Google and didn't find anything...My company is migrating data from one old version of Oralce (8.1.7.2) to Oracle Version 9.2.0.6.The database is basically personal information and when we migrated a record over to the ...

Oracle Error in MRU: row= 0, ORA-20001: ORA-20001: Current version of data

I have this error again - and really don't know where to begin looking for the answer.I find it very worrying that this error is generated by the internals of Apex which I cannot see. There is no indication as to why / what causes this in a general sense. Could someone explain in english / pseudo co ...

Oracle ora-01034 , ora-27101 - help!

hi, we are using 9i database it was normally working but today when attemp to make a connection gives errors ora-01034 , ora-27101 and srv4 error 2: no such file or directory cannot restart cannot shutdown , cheched the sid its ok, the value is correct (i checked case sensitiveness ) the db is on so ...

Oracle ORA-01122, ORA-01110 and ORA-01251

When we are opening the database following errors are coming in sequence as follows:ORA-01122, ORA-01110 and ORA-01251Other facts:We don’t have any backup.Database is not in archive mode.Personally I don't see any hope.What you guys think? ...

Oracle tnsnames.ora, listener.ora, config.ora

Some body please tell me the jobs of tnsnames.ora, listener.ora, and config.ora ...

Oracle don't want these errors in my statistics: ora-25228, ora-25254, ora-1

I created a trigger to check out and insert the servererror to a table. but all i see the errors are: ora-25228, ora-25254, ora-1. so i eliminated these errors by doing: if var_errnum 25228 AND var_errnum 25254 AND var_errnum 1 THENselect username, osuser, machine, process, programinto var_user, var ...

Oracle tnsnames.ora, sqlnet.ora & listener.ora files are not exit

DB version: 10.2Hello All,I just joined the project and notice tnsnames.ora, sqlnet.ora & listener.ora files are not exit under $ORACLE_HOME/network/admin.But still we can connect to the database,From command prompt or via enterprise manager studio from client site.Any idea? OR what is the best ...

Oracle Error in MRU: row= 1, ORA-20001: ORA-20001: Current version of data in data

I have a page that has a form to my issue table and on the same page, in a different region, I have a tabular report that shows the issue_activity for the specified issue. The primary key on the issue table is the issue_no which is a sequence and the primary key on the issue_activity table is (issue ...

Oracle ORA-39001, ORA-39000 and ORA-31619 Errors while impdp from linux to windows

When I use expdp and impdp on a database inside the same machine or between 2 machines using the same OS everything is OK.But when I want to cross the same database expdp and impdp, for instance:I expdp on linux RedHat 4 ES and want to impdp on Windows XPthen I have the folowwing errors:ORA-39001, O ...

Oracle ORA-20020: ORA-21000: error number argument to raise_application_error of 2

I am framing one dynamic insert statement for a table which contains 208 columns in a procedure.While i execute a procedure i got an error like this ERROR at line 1:ORA-20020: ORA-21000: error number argument to raise_application_error of 20001 is out of range Please advice ...

Oracle Client installation with Net Configuration-Assistant : ora-00604 / ora-0224

I am trying to install a client on a remote computer with Net Configuration-Assistant. When testing connection as user system I always get oracle errorsora-00604 / ora-0224.When I try connection with sys the reaction is : should be done with sysdba or sysoper privilege.On command line level I can lo ...

Oracle Change port 1521 in tnsnames.ora & listener.ora

DBAs,some how I used different port than port 1521 in my DB installation.DB works fine.But we have some rule for our firewall.So I need to bring back my listener to use port 1521.What should I do?Here are the steps I planned to do, please confirm.Stop listener.ora.Change port 1521 in tnsnames.ora ...

Oracle ORA-01113,ORA-01110

I am getting ORA-01113,ORA-01110 these error while mounting my database.Plz give solution immediately .Advance ...

ORACLE TRANSPARENT GATEWAY FOR SQL SERVER ERRORS ORA-00910 ORA-02063

I have the transparent gateway(10g) installed for sql server 7 and when I realize some consultation returns to me the mistake ORA-00910 ORA-02063 Someone knows something of this mistake ...

Oracle Changes to tnsadmin.ora listener.ora for multiple DB instances

I've read quite a few posts on changes to the tnsadmin.ora and listener.ora files and I'm still not quite getting what I need to do to get the listener to automatically connect client requests to their respective DB's. Apologies if this is a basic question, but here's my problem....I've got two DBs ...

Oracle ORA-20500+ ORA-02055+ORA-02068+ORA-03113

i got this error in my front end .....any idea what might be the reason?Failed: ORA-20500: ORA-20500: ORA-20500: ORA-20500: ORA-02055: distributed update operation failed; rollback requiredORA-02068: following severe error from MUDR2SEBL(db_link name)ORA-03113: end-of-file on communication channel ...

Oracle Configuring listener.ora & tnsnames.ora for new/other instance on same Mach

DBMS: Oracle 9i Rel. 9.2.0.8 EEPlatform: AIX 5.3 ML51st Instance: pkms2nd instance (New): pkconfigCase:Configuring The Network Connection for New Instance on The Same Machine.Description:I have instance already available on the machine and I created a new instance on the same machine but there the l ...

Oracle Errors ORA-01034, ORA-27101 and ORA-01033

I have Oracle 9i DB and DevSuite 10g installed on my laptop. There are three databases on my machine.Recently, I tried to install Oracle Discoverer 10g and that's where the problem started. I could no longer connect to the databse using either SQL*Plus, TOAD or even from the front end application.I ...

Oracle Relation between tnsname.ora, Listner.ora, Init.ora

HiCan any body send me link of documentation which tells the relation betweentnsnames.ora, listner.ora, init.ora file.and any link which tells what is sid, Service_name, db_name and service. and how to see them allthanksMessage was edited by: umesh049 ...

Oracle ORA-00610 & ORA-07445 in differenct DB last month

I am seeing ORA-00610 & ORA-07445 in differenct DB in there alert log file generated in mid march , Now its gone, wondering should i ignore these or still fix it ?I found metalink notes asking for adjust SQL>alter system set JOB_QUEUE_PROCESSES=50 scope=both; & SQL>alter system set "_d ...

Oracle ora-12541 ORA-12154: TNS:could not resolve the connect identifier specified

I am having trouble obtaining an ODBC connection from a client XE to a server XE. ora-12541 ORA-12154: TNS:could not resolve the connect identifier specified I am new to Oracle.I have oracle client XE running on my XP pro box.I have oracle server XE running on an XP pro box on the LAN.I am trying to ...

Oracle Regading the ORA Error - ORA-error stack (00600[12333])

Anyone known of the ORA Error (ORA-error stack (00600[12333]) ) , as per the metalinks update , we are not closing the issue . As we are getting this error more regularly. if anyone known of this ORA error occurence pls share .... ...

Oracle ORA-01157 ORA-01110 ORA-27037 during open resetlogs

after point in time recovery of a database we do a 'open resetlogs' and got these errors, ORA-01157 ORA-01110 ORA-27037 , all of them regarding the missing tempfiles from temp tablespace. As we see in the alert.log, database is doing a 'Dictionary check beginning' during this the DBWR-Process tries ...