Oracle XML-22043: (Error) Extension function error: Method not found 'getDtformat'

We are using a custom made function for formatting date in the XSL transformation. This jar file has been kept under the domain_name/lib folder, and it is working as expected in our Windows environment. However when I tried to deploy it in Linux environment, it is giving the error XML-22043: (Error) Extension function error: Method not found 'getDtformat' (Full stack trace attached below)

Appreciate your help!

Regards,
Ebrahim Badusha.

<Oct 21, 2011 3:04:34 PM EDT> <Error> <oracle.soa.bpel.engine.xml> <BEA-000000> <javax.xml.transform.TransformerException: oramds:/deployed-composites/default/MyProject_rev1.0/xsl/xFormValidationsBRE.xsl<Line 27, Column 252>: XML-22043: (Error) Extension function error: Method not found 'getDtformat'>
<Oct 21, 2011 3:04:34 PM EDT> <Error> <oracle.soa.bpel.engine.xml> <BEA-000000> <
javax.xml.xpath.XPathExpressionException: javax.xml.transform.TransformerException: oramds:/deployed-composites/default/MyProject_rev1.0/xsl/xFormValidationsBRE.xsl<Line 27, Column 252>: XML-22043: (Error) Extension function error: Method not found 'getDtformat'
at oracle.xml.xpath.JXPathExpression.evaluate(JXPathExpression.java:242)
at com.collaxa.cube.xml.xpath.BPELXPathUtil.evaluate(BPELXPathUtil.java:240)
at com.collaxa.cube.engine.ext.bpel.v2.wmp.assign.BPEL2FromToOperationPerformer.evalFromExpression(BPEL2FromToOperationPerformer.java:320)
at com.collaxa.cube.engine.ext.bpel.v2.wmp.assign.BPEL2FromToOperationPerformer.evalFromValue(BPEL2FromToOperationPerformer.java:220)
at com.collaxa.cube.engine.ext.bpel.v2.wmp.assign.BPEL2FromToOperationPerformer.perform(BPEL2FromToOperationPerformer.java:55)
at com.collaxa.cube.engine.ext.bpel.v2.wmp.BPEL2AssignWMP.__executeStatements(BPEL2AssignWMP.java:69)
at com.collaxa.cube.engine.ext.bpel.common.wmp.BaseBPELActivityWMP.perform(BaseBPELActivityWMP.java:158)
at com.collaxa.cube.engine.CubeEngine._performActivity(CubeEngine.java:2463)
at com.collaxa.cube.engine.CubeEngine.performActivity(CubeEngine.java:2334)
at com.collaxa.cube.engine.CubeEngine.handleWorkItem(CubeEngine.java:1115)
at com.collaxa.cube.engine.dispatch.message.instance.PerformMessageHandler.handleLocal(PerformMessageHandler.java:73)
at com.collaxa.cube.engine.dispatch.DispatchHelper.handleLocalMessage(DispatchHelper.java:220)
at com.collaxa.cube.engine.dispatch.DispatchHelper.sendMemory(DispatchHelper.java:328)
at com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4350)
at com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4281)
at com.collaxa.cube.engine.CubeEngine.createAndInvoke(CubeEngine.java:679)
at com.collaxa.cube.engine.ejb.impl.CubeEngineBean.createAndInvoke(CubeEngineBean.java:103)
at com.collaxa.cube.engine.ejb.impl.CubeEngineBean.syncCreateAndInvoke(CubeEngineBean.java:145)
at com.collaxa.cube.engine.ejb.impl.bpel.BPELEngineBean.syncCreateAndInvoke(BPELEngineBean.java:111)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.bea.core.repackaged.springframework.jee.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:104)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor$1.run(JpsAbsInterceptor.java:94)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor.runJaasMode(JpsAbsInterceptor.java:81)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor.intercept(JpsAbsInterceptor.java:112)
at oracle.security.jps.ee.ejb.JpsInterceptor.intercept(JpsInterceptor.java:105)
at sun.reflect.GeneratedMethodAccessor1289.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.bea.core.repackaged.springframework.jee.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:69)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy316.syncCreateAndInvoke(Unknown Source)
at com.collaxa.cube.engine.ejb.impl.bpel.BPELEngineBean_51369e_ICubeEngineLocalBeanImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:39)
at com.collaxa.cube.engine.ejb.impl.bpel.BPELEngineBean_51369e_ICubeEngineLocalBeanImpl.syncCreateAndInvoke(Unknown Source)
at com.collaxa.cube.engine.delivery.DeliveryHandler.callCreateAndInvoke(DeliveryHandler.java:790)
at com.collaxa.cube.engine.delivery.DeliveryHandler.initialRequestAnyType(DeliveryHandler.java:528)
at com.collaxa.cube.engine.delivery.DeliveryHandler.initialRequest(DeliveryHandler.java:487)
at com.collaxa.cube.engine.delivery.DeliveryHandler.request(DeliveryHandler.java:162)
at com.collaxa.cube.engine.ejb.impl.CubeDeliveryBean.request(CubeDeliveryBean.java:493)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.bea.core.repackaged.springframework.jee.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:104)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor$1.run(JpsAbsInterceptor.java:94)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor.runJaasMode(JpsAbsInterceptor.java:81)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor.intercept(JpsAbsInterceptor.java:112)
at oracle.security.jps.ee.ejb.JpsInterceptor.intercept(JpsInterceptor.java:105)
at sun.reflect.GeneratedMethodAccessor1289.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.bea.core.repackaged.springframework.jee.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:69)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy312.request(Unknown Source)
at com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:39)
at com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.request(Unknown Source)
at oracle.fabric.CubeServiceEngine.request(CubeServiceEngine.java:380)
at oracle.integration.platform.blocks.mesh.SynchronousMessageHandler.doRequest(SynchronousMessageHandler.java:139)
at oracle.integration.platform.blocks.mesh.MessageRouter.request(MessageRouter.java:179)
at oracle.integration.platform.blocks.mesh.MeshImpl.request(MeshImpl.java:155)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at oracle.integration.platform.metrics.PhaseEventAspect.invoke(PhaseEventAspect.java:59)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy329.request(Unknown Source)
at oracle.integration.platform.blocks.soap.WebServiceEntryBindingComponent.doMessageProcessing(WebServiceEntryBindingComponent.java:1281)
at oracle.integration.platform.blocks.soap.WebServiceEntryBindingComponent.processIncomingMessage(WebServiceEntryBindingComponent.java:859)
at oracle.integration.platform.blocks.soap.FabricProvider.processMessage(FabricProvider.java:113)
at oracle.j2ee.ws.server.provider.ProviderProcessor.doEndpointProcessing(ProviderProcessor.java:1187)
at oracle.j2ee.ws.server.WebServiceProcessor.invokeEndpointImplementation(WebServiceProcessor.java:1081)
at oracle.j2ee.ws.server.provider.ProviderProcessor.doRequestProcessing(ProviderProcessor.java:581)
at oracle.j2ee.ws.server.WebServiceProcessor.processRequest(WebServiceProcessor.java:232)
at oracle.j2ee.ws.server.WebServiceProcessor.doService(WebServiceProcessor.java:192)
at oracle.j2ee.ws.server.WebServiceServlet.doPost(WebServiceServlet.java:459)
at oracle.integration.platform.blocks.soap.FabricProviderServlet.doPost(FabricProviderServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:31
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUt
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.jav
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:1
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:13
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppS
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletC
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.j
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

Edited by: Ebrahim Badusha on Oct 21, 2011 12:42 PM

Oracle XML CLOB out of memory error

I am running several of Oracle's XML toolsto store large XML documents in Oracle.I am successful with a 3 MB file, but notwith a 20 MB file. I get an "out of memory"exception in LobPlsqlUtil.class. The CLOB is accessed through the methodCLOB.getCharacterStream(), which is thenhanded off to an XMLPar ...

Oracle "XML page cannot be displayed" error

Using XML output on a table with more than a few rows falls over with a "XML page cannot be displayed" error. Sometimes only the error is displayed, sometimes some rows are displayed with this error at the end of the page (eg the DEMO_STATES table)Can anyone advise if there is some sort of limiter a ...

Oracle Maps example - map printing function error

I have been trying the various examples, and all have worked great up until I tried to use the map printing function. Clicking on the 'click here to print' gave the following error:Line: 8150Char: 1Error: 'null' is null or not and object8150 in oraclemaps.js appears to reference the class 'printimag ...

Oracle Maps example - map printing function error

Error when try to print ...

Oracle XML Embedded in Stored Function - Performance Considerations

A developer in my company approached us with a question about performance considerations while writing stored procedures or functions that embed XML. The primary use for this function would be to provide a quick decision given a set of parameters. The function will use the input parameters along wit ...

Oracle JDeveloper J2ME "Configure The Extension" viewlet error

The "Configure The Extension" viewlet on the following page doesn't work.http://otn.oracle.com/products/jdev/htdocs/partners/addins/exchange/j2me/index.htmlThe error message from the JRE console is:"http://otn.oracle.com/products/jdev/htdocs/partners/addins/exchange/j2me/config.vp/Config.viewletjava ...

Error using Oracle XML DB functionality

I am trying to invoke a command using ODBC from the Oracle library.Specifically I am trying to register a schema.CDatabase Cdbase;Cdbase.OpenEx( sODBCString, CDatabase:penReadOnly | CDatabase::noOdbcDialog );CString sRegister = _T("call dbms_xmlschema.registerSchema('http://persefone:8080/home/ ...

Oracle Message : (304) ORA-01041: internal error. hostdef extension

We use webmethods enterprise for integration.We connect ERP and CRM applications using webMethods. webMethods also stores its own crossreferencing data in a Oracle DB Server. We get this error once in a while, while storing or retriving information from the database.can anyone point me to a link whe ...

Oracle XML parse error

Using Oracle Migration Workbench I am trying to add my XML file into the Microsoft Access XML Data File slot and I get and error that reads:XML parse error...........at line 17481, character 46: Expected ','.How may I rectify this problem? ...

Oracle ORA-24347 Warning of a NULL column in an aggregate function Error

Hi, I'm recieving the following error:ORA-24347 Warning of a NULL column in an aggregate functionCause: A null column was processed by an aggregate function. Action: An OCI_SUCCESS_WITH_INFO is returned.When issuing this query:SELECT ALL SYS.DBA_SYS_PRIVS.GRANTEE, SYS.DBA_SYS_PRIVS.PRIVILEGE,SYS.DBA ...

Oracle AVG as an analytic function - gives error ORA-0439

I'm trying my first implementation of AVG as an analytic function. I took the following query which gave a simple average:SELECTPERSON.LASTNAME, COUNT(TO_NUMBER(RPTOBS.OBSVALUE)) CNT, AVG(TO_NUMBER(RPTOBS.OBSVALUE)) AVRGFROM TUT.PERSON PERSON, TUT.RPTOBS RPTOBS WHERE PERSON.PID = RPTOBS.PID AND RPTO ...

Oracle Error mapping function in external procedure call

I'm trying to create an external procedure in PL/SQL8.1 to run an operating system command from within a PL/SQL block.The C function couldn't be simpler:extern void host_command(char *command){(void)system(command);}It's even ignoring the return value of SYSTEM!I've generated what I THINK is a share ...

Oracle ORA-06521: PL/SQL: Error mapping function

I have an external function:#include <stdio.h>#include <stdlib.h>#include <string.h>char buffer[80];char* streamslog( char text[10]){printf("Hello");switch(text[0]){case 'W': return ("char W received"); default :return ("DEFAULT");}} Which working fine when I access it from PL/SQL ...

Oracle Error creating function based index on windows

I created a deterministic function accepting a varchar2 argument and returning a varchar2 value.On 9i Release 1 on solaris, I can create an index on <table> (functionName(columnName)).On 9i Release 1 on windows, attempting to create the same index results in an error "ORA-01450: maximum key le ...

Oracle xml parse error

I am using oracle database 817.I have granted appropriate java privileges & also executed the load.sql methodI am getting the foll error on executing the code *ERROR at line 1:ORA-20100: Error occurred while parsing: PI names starting with 'xml' are reserved.ORA-06512: at "SUSHANT.XMLPARSER", li ...

ORA-03113 error when setting up Oracle XML DB Basic Demo

When I try to install XDB_UTILITY package using the command @SQL/xdbUtility, immediately after the view is created successfully, I get the out-of-file error. The error is caused by "select value(x) into dbxml from xdb_database_summary x".The database I am using is 9.2.0.2 updagrated from 9.2.0.1 and ...

Oracle How to find the cause of a function error?

can anyone tell me how I trace a function sequence error?I have a piece of VB code (that has worked on many occassions, which runs to 9i.I deleted the contents of my tables and then tried to run the same code again but got the following error message:run time error '-2147467259 (80004005)':[Oracle][ ...

Oracle xml query error

I'm trying a simple xml query on oracle 9.2.0.1 and get an error. The query is:select value(r).extract('REPORT/ADDENDUM').getStringVal()from reports rAnd the error isORA-00904: "R": invalid identifier ...

Oracle DBMS_LDAP call fails with ORA-06512 Error Mapping function

I am facing a problem with workflow integration with LDAP.I receiveORA-6512 Error Mapping Function on one particular line within the WF_LDAP.get_cfg_val procedure. WHILE my_entry IS NOT NULLLOOPmy_vals := DBMS_LDAP.get_values (p_session,my_entry,p_name); The documentation says: ORA-06521 PL/SQL: Err ...

Oracle XML extract error

This is my table: SQL> describe UCCNET_REGISTRY_CAT_ITEM;Name Null? Type -------- UCCNET_REGISTRY_CAT_ITEM_KEY NOT NULL NUMBERXML XMLTYPEEAN_UCC_PROXY_KEY NUMBERDOCUMENT_NAME VARCHAR2(256)SQL> and this is my statement that is supposed to extract the XML data: select p.XML from UCCNET_REGISTRY_ ...

Oracle Member Function Error

I am using Oracle 9i on Windows XP.I am trying to complete a tutorial for my Database class and have come across an error which I can't get around. I enter the following code which seems to work:ALTER TYPE student_type REPLACE AS OBJECT(FirstName varchar2(15),LastName varchar2(15),Address address_ty ...

Oracle error creating function based index

i keep getting ORA-13203 errors when creating a function-based index. The function is owned by another schema but the the user creating the function has execute privilegesgis@gis.world> create index mpp_nc_sidx on MPP_NONCOMPLETE(GIS.DD832UTM(LON*-1,LAT))2 indextype is mdsys.spatial_index3 parame ...

Oracle XML Schema causing an ORA-00600 error

I have an xml schema that generates an ORA-00600 error when I try to create a table containing an XMLType column that references the schema.Here's an extract from my xmlschema with the offending bit in bold:<xs:simpleType name="PrintIndicator"><xs:restriction base="xs:string"><xs:leng ...

Oracle URGENT!!!! Error with function returning VARRAY

I have a function returning VARRAY.When I call the function I receive the error "PLS-00382: expression is of wrong type".SQL CODE:MY_VARRAY := FUNCTION_RETUN_VARRAY();PS: every codes compile, except this piece of code. ...

Oracle getVector function Error

When i use getVector function to get a vector field value from database, i haved encountered an error 'Debug Assertion Failed! ... File:dbgheap.c ... Exception: _CrtlsValidHeapPointer(pUserData) ...'. My code is as follows:...while (rs->next()){getVector (rs, 2, c2);....}...(typedef vector<str ...

Oracle XML parsing error

i am totally new to using oracle xmldb and have a pretty simple problem but not able to get around it. I am using the sample code below and when i use it with some sample XML it give a parsing error, i am not sure why , the xml looks well formed , hoping it is some elementary error and not a bug.Ora ...

Oracle xml parser error from XMLType colum

I use Jdeveloper 10g to implement java program to access the xml data stored in Ora9i Database. I am still using the thin JDBC Driver. As I tried to retrieve the xml data stored as XMLtype in a column, I could not get the XMLType using the sample codes provided by JavaAPI for XMLType. Then I tried t ...

Oracle XML Schema registration error

We installed XMLDB on Oracle Server Enterprise Edition 9.2.0.3 (AIX 4.3 version).The status from DBA_REGISTRY for Oracle XML DB is VALID.When trying to register schema, we get following error:ERROR at line 1:ORA-01031: insufficient privilegesORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 0ORA-06512: a ...

Oracle ERROR in FUNCTION

I have created a functions which takes squence name as parameter that is passed by frontend.After gettin it i have to generate a NEXTVAL and i have to written tht value to the front end.I have tried with the belowCREATE OR REPLACE FUNCTION prn_nGetSquenceID(strSqName IN VARCHAR2) RETURN NUMBERASl_in ...