Forum Stats

  • 3,837,271 Users
  • 2,262,245 Discussions
  • 7,900,244 Comments

Discussions

tion was: ORA-00604: error occurred at recursive SQL level 1

Tony007
Tony007 Member Posts: 4,248 Bronze Trophy

hi am geting this error after i change character set to US7ASCII;

am in oracle solaris 11.4 and 12c oracle forms

i did alter database character set internal_use US7ASCII;


at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)

Caused By: oracle.mds.internal.persistence.db.fcf.MDSDBIOException: weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection for datasource 'mds-owsm'. The DBMS driver exception was: ORA-00604: error occurred at recursive SQL level 1

ORA-31011: XML parsing failed

ORA-19213: error occurred in XML processing at lines 1

LPX-00007: unexpected end-of-file encountered


    at oracle.mds.internal.persistence.db.JNDIConnectionManagerImpl.fetchConnection(JNDIConnectionManagerImpl.java:297)

    at oracle.mds.internal.persistence.db.JNDIConnectionManagerImpl.init(JNDIConnectionManagerImpl.java:184)

    at oracle.mds.internal.persistence.db.ConnectionManagerFactory.createConnectionManager(ConnectionManagerFactory.java:72)

    at oracle.mds.internal.persistence.db.DBStoreUtils.getConnectionManager(DBStoreUtils.java:564)

    at oracle.mds.persistence.stores.db.DBMetadataStore.checkRepositoryCompatibility(DBMetadataStore.java:1127)

    at oracle.mds.persistence.stores.db.DBMetadataStore.checkCompatibility(DBMetadataStore.java:1512)

    at oracle.mds.persistence.stores.db.DBMetadataStore.initDBMetadataStore(DBMetadataStore.java:2114)

    at oracle.mds.persistence.stores.db.DBMetadataStore.<init>(DBMetadataStore.java:391)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

    at oracle.mds.persistence.MetadataStore.create(MetadataStore.java:352)

    at oracle.mds.persistence.MetadataStore.create(MetadataStore.java:239)

    at oracle.mds.persistence.MetadataStore.create(MetadataStore.java:208)

    at oracle.mds.config.PConfig.getMetadataStore(PConfig.java:2178)

    at oracle.mds.config.PConfig.getStoreForStoreUsage(PConfig.java:2122)

    at oracle.mds.config.PConfig.loadFromBean(PConfig.java:1046)

    at oracle.mds.config.PConfig.<init>(PConfig.java:891)

    at oracle.mds.config.MDSConfig.loadFromBean(MDSConfig.java:1313)

    at oracle.mds.config.MDSConfig.loadFromElement(MDSConfig.java:1385)

    at oracle.mds.config.MDSConfig.<init>(MDSConfig.java:927)

    at oracle.mds.core.MDSInstance.getMDSConfigFromDocument(MDSInstance.java:3504)

    at oracle.mds.core.MDSInstance.access$400(MDSInstance.java:464)

    at oracle.mds.core.MDSInstance$MDSInstanceStore$1.call(MDSInstance.java:4098)

    at oracle.mds.core.MDSInstance$MDSInstanceStore$1.call(MDSInstance.java:4082)

    at java.util.concurrent.FutureTask.run(FutureTask.java:266)

    at oracle.mds.core.MDSInstance$MDSInstanceStore.getOrCreateMDSInstance(MDSInstance.java:4124)

    at oracle.mds.core.MDSInstance.getOrCreateInstanceInternal(MDSInstance.java:2949)

    at oracle.mds.core.MDSInstance.getOrCreateInstance(MDSInstance.java:918)

    at oracle.adf.share.config.ADFMDSConfig.parseADFConfiguration(ADFMDSConfig.java:159)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    at java.lang.reflect.Method.invoke(Method.java:498)

    at oracle.adf.share.config.ADFConfigImpl.getResultFromComponent(ADFConfigImpl.java:658)

    at oracle.adf.share.config.ADFConfigImpl.getConfigObject(ADFConfigImpl.java:741)

    at oracle.adf.share.config.ADFConfigImpl.getConfigObject(ADFConfigImpl.java:707)

    at oracle.adf.share.config.ADFConfigImpl.getMDSInstance(ADFConfigImpl.java:788)

    at oracle.adf.share.config.ADFConfigImpl.getMDSInstance(ADFConfigImpl.java:775)

    at oracle.adf.share.config.ADFContextMDSConfigHelperImpl.getMDSInstance(ADFContextMDSConfigHelperImpl.java:310)

    at oracle.adf.share.ADFContext.getMDSInstanceAsObject(ADFContext.java:2310)

    at oracle.wsm.repository.service.DefaultRepositoryService.createMDSInstance(DefaultRepositoryService.java:72)

    at oracle.wsm.repository.mds.MDSInstanceFactory.getMDSInstance(MDSInstanceFactory.java:140)

    at oracle.wsm.policymanager.bean.AbstractBean.getRepository(AbstractBean.java:608)

    at oracle.wsm.policymanager.bean.AbstractBean.createSession(AbstractBean.java:434)

    at oracle.wsm.policymanager.bean.AbstractBean.getWriteTimestamp(AbstractBean.java:622)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    at java.lang.reflect.Method.invoke(Method.java:498)

    at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)

    at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)

    at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

    at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:101)

    at oracle.wsm.policymanager.bean.ejb.impl.EjbUtil.removeCurrentADFContext(EjbUtil.java:89)

    at oracle.wsm.policymanager.bean.ejb.impl.AlgorithmProcessorEJB.removeCurrentADFContext(AlgorithmProcessorEJB.java:229)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    at java.lang.reflect.Method.invoke(Method.java:498)

    at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:94)

    at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

    at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:101)

    at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:101)

    at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

    at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:101)

    at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)

    at org.jboss.weld.ejb.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:52)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    at java.lang.reflect.Method.invoke(Method.java:498)

    at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:94)

    at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

    at com.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:101)

    at oracle.security.jps.ee.ejb.JpsAbsInterceptor$1.run(JpsAbsInterceptor.java:131)

    at java.security.AccessController.doPrivileged(Native Method)

    at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

    at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)

    at oracle.security.jps.ee.ejb.JpsAbsInterceptor.runJaasMode(JpsAbsInterceptor.java:118)

    at oracle.security.jps.ee.ejb.JpsAbsInterceptor.intercept(JpsAbsInterceptor.java:197)

    at oracle.security.jps.ee.ejb.JpsInterceptor.intercept(JpsInterceptor.java:112)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    at java.lang.reflect.Method.invoke(Method.java:498)

    at com.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:94)

    at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

    at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)

    at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)

    at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

    at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)

    at com.sun.proxy.$Proxy255.getWriteTimestamp(Unknown Source)

    at oracle.wsm.policymanager.bean.ejb.impl.AlgorithmProcessor_y4614n_IRemoteAlgorithmProcessorImpl.__WL_invoke(Unknown Source)

    at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invokeInternal(SessionRemoteMethodInvoker.java:54)

    at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:21)

    at oracle.wsm.policymanager.bean.ejb.impl.AlgorithmProcessor_y4614n_IRemoteAlgorithmProcessorImpl.getWriteTimestamp(Unknown Source)

    at oracle.wsm.policymanager.client.AlgorithmProcessorDelegate$7.run(AlgorithmProcessorDelegate.java:295)

    at oracle.wsm.policymanager.client.AlgorithmProcessorDelegate$7.run(AlgorithmProcessorDelegate.java:292)

    at java.security.AccessController.doPrivileged(Native Method)

    at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

    at oracle.security.jps.internal.jaas.AccActionExecutor.execute(AccActionExecutor.java:70)

    at oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:282)

    at oracle.security.jps.internal.jaas.CascadeActionExecutor$SubjectPrivilegedExceptionAction.run(CascadeActionExecutor.java:82)

    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:386)

    at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:163)

    at weblogic.security.Security.runAs(Security.java:62)

    at oracle.security.jps.wls.jaas.WlsActionExecutor.execute(WlsActionExecutor.java:50)

    at oracle.security.jps.internal.jaas.CascadeActionExecutor.execute(CascadeActionExecutor.java:55)

    at oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:282)

    at oracle.wsm.policymanager.client.AlgorithmProcessorDelegate.getWriteTimestamp(AlgorithmProcessorDelegate.java:292)

    at oracle.wsm.config.ConfigurationManager$BeanHolder.isFailed(ConfigurationManager.java:352)

    at oracle.wsm.config.ConfigurationManager.initializeAccessors(ConfigurationManager.java:2287)

    at oracle.wsm.config.ConfigurationManager.reInitializeAccessors(ConfigurationManager.java:2999)

    at oracle.wsm.config.ConfigurationManager.getProperty(ConfigurationManager.java:2042)

    at oracle.wsm.policymanager.web.PolicyManagerValidator.getJndiLookupCSFKey(PolicyManagerValidator.java:596)

    at oracle.wsm.policymanager.web.PolicyManagerValidator.getActionExecutor(PolicyManagerValidator.java:491)

    at oracle.wsm.policymanager.web.PolicyManagerValidator.init(PolicyManagerValidator.java:196)

    at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:356)

    at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:307)

    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344)

    at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)

    at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)

    at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)

    at weblogic.servlet.internal.StubSecurityHelper.initServletInstance(StubSecurityHelper.java:99)

    at weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:87)

    at weblogic.servlet.internal.StubLifecycleHelper.createOneInstance(StubLifecycleHelper.java:74)

    at weblogic.servlet.internal.StubLifecycleHelper.<init>(StubLifecycleHelper.java:57)

    at weblogic.servlet.internal.StubLifecycleHelper.<init>(StubLifecycleHelper.java:31)

    at weblogic.servlet.internal.ServletStubImpl.initStubLifecycleHelper(ServletStubImpl.java:676)

    at weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.java:615)

    at weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletContext.java:2072)

    at weblogic.servlet.internal.WebAppServletContext.loadServletsOnStartup(WebAppServletContext.java:2049)

    at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1938)

    at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3191)

    at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1864)

    at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:919)

    at weblogic.application.internal.ExtensibleModuleWrapper$StartStateChange.next(ExtensibleModuleWrapper.java:360)

    at weblogic.application.internal.ExtensibleModuleWrapper$StartStateChange.next(ExtensibleModuleWrapper.java:356)

    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:45)

    at weblogic.application.internal.ExtensibleModuleWrapper.start(ExtensibleModuleWrapper.java:138)

    at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:124)

    at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:233)

    at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:228)

    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:45)

    at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:78)

    at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:52)

    at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:752)

    at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:45)

    at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:262)

    at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:66)

    at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:165)

    at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:90)

    at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:274)

    at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:507)

    at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:53)

    at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:202)

    at weblogic.management.deploy.internal.AppTransition$2.transitionAppInternal(AppTransition.java:53)

    at weblogic.management.deploy.internal.AppTransition.transitionApp(AppTransition.java:138)

    at weblogic.management.deploy.internal.ConfiguredDeployments$2.doItem(ConfiguredDeployments.java:741)

    at weblogic.management.deploy.internal.parallel.BucketInvoker.invoke(BucketInvoker.java:138)

    at weblogic.management.deploy.internal.ConfiguredDeployments.transitionAppsParallel(ConfiguredDeployments.java:749)

    at weblogic.management.deploy.internal.ConfiguredDeployments.transitionAppsParallel(ConfiguredDeployments.java:702)

    at weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:381)

    at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:233)

    at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:219)

    at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:133)

    at weblogic.server.AbstractServerService.postConstruct(AbstractServerService.java:76)

    at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    at java.lang.reflect.Method.invoke(Method.java:498)

    at org.glassfish.hk2.utilities.reflection.ReflectionHelper.invoke(ReflectionHelper.java:1287)

    at org.jvnet.hk2.internal.ClazzCreator.postConstructMe(ClazzCreator.java:333)

    at org.jvnet.hk2.internal.ClazzCreator.create(ClazzCreator.java:375)

    at org.jvnet.hk2.internal.SystemDescriptor.create(SystemDescriptor.java:487)

    at org.glassfish.hk2.runlevel.internal.AsyncRunLevelContext.findOrCreate(AsyncRunLevelContext.java:305)

    at org.glassfish.hk2.runlevel.RunLevelContext.findOrCreate(RunLevelContext.java:85)

    at org.jvnet.hk2.internal.Utilities.createService(Utilities.java:2126)

    at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:116)

    at org.jvnet.hk2.internal.ServiceLocatorImpl.getService(ServiceLocatorImpl.java:698)

    at org.jvnet.hk2.internal.ThreeThirtyResolver.resolve(ThreeThirtyResolver.java:78)

    at org.jvnet.hk2.internal.ClazzCreator.resolve(ClazzCreator.java:212)

    at org.jvnet.hk2.internal.ClazzCreator.resolveAllDependencies(ClazzCreator.java:235)

    at org.jvnet.hk2.internal.ClazzCreator.create(ClazzCreator.java:358)

    at org.jvnet.hk2.internal.SystemDescriptor.create(SystemDescriptor.java:487)

    at org.glassfish.hk2.runlevel.internal.AsyncRunLevelContext.findOrCreate(AsyncRunLevelContext.java:305)

    at org.glassfish.hk2.runlevel.RunLevelContext.findOrCreate(RunLevelContext.java:85)

    at org.jvnet.hk2.internal.Utilities.createService(Utilities.java:2126)

    at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:116)

    at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:90)

    at org.glassfish.hk2.runlevel.internal.CurrentTaskFuture$QueueRunner.oneJob(CurrentTaskFuture.java:1237)

    at org.glassfish.hk2.runlevel.internal.CurrentTaskFuture$QueueRunner.run(CurrentTaskFuture.java:1168)

    at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:681)

    at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)

    at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)

    at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)

    at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)

    at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)

    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)

    at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)

Caused By: weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection for datasource 'mds-owsm'. The DBMS driver exception was: ORA-00604: error occurred at recursive SQL level 1

ORA-31011: XML parsing failed

ORA-19213: error occurred in XML processing at lines 1

LPX-00007: unexpected end-of-file encountered


    at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:278)

    at weblogic.jdbc.common.internal.WLDataSourceImpl.getPoolConnection(WLDataSourceImpl.java:563)

    at weblogic.jdbc.common.internal.WLDataSourceImpl.getConnectionInternal(WLDataSourceImpl.java:660)

    at weblogic.jdbc.common.internal.WLDataSourceImpl.getConnection(WLDataSourceImpl.java:611)

    at weblogic.jdbc.common.internal.WLDataSourceImpl.getConnection(WLDataSourceImpl.java:

Answers

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 7,295 Employee

    I cannot speak to the specific error, but can say that trying to use an old 7bit character set will cause you problems. Why are you trying to use it anyway?

    You need to use something like one of these:

    • WE8ISO8859P1
    • WE8ISO8859P15
    • UTF8

    There are many others, but using US7ASCII is not recommended and likely not supported.


    Michael Ferrante

    Senior Principal Product Manager

    Oracle

    Twitter: @OracleFormsPM

  • Tony007
    Tony007 Member Posts: 4,248 Bronze Trophy

    my application database is character is

    • but my repo datbase is UTF8


  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 7,295 Employee

    It is unclear what you are saying. Did you now change the DB based on what I said?

    You opened this thread saying:

    ... after i change character set to US7ASCII; ... i did alter database character set internal_use US7ASCII;

    Bottom line is that you should not use 7ASCII anywhere - not in the DB or in Forms. Your NLS_LANG in the Forms environment should be something like one of the examples I shared above.


    Michael Ferrante

    Senior Principal Product Manager

    Oracle

    Twitter: @OracleFormsPM