Amicuk Programming Answers

Index > ora 03111 >

ora 03111


ORA-03111 - JCA Binding error while invoking a stored procedure in DB

Category:DefaultRelease time:2015-10-11Views:130

Hi, We are facing this problem for one interface alone. Need expert advice to fix this problem.. This is scheduled to run once in a day and fails daily for past 2 weeks.. We receive below error as response.. Same interface worked fine for past 1 yr..[More]

PL/SQL report errors: ORA-01422

Category:DefaultRelease time:2015-10-11Views:130

Hi all, (before i you read i would like to say i have searched the net for this error code but nothing shows up like this problem..) I am getting an error problem when i select certain Schemas from a list on an apex app. page, it only works for some[More]

Ora-00604 error and ora 01000 error while report generation.

Category:DefaultRelease time:2015-10-11Views:130

hi all, I am trying to generate the multiple reports of same template through a program. While this job is running, i get the following error at the BIP console and the reports don't get generated. [101711_044115578][][EXCEPTION] java.sql.SQLExceptio[More]

EA2: ORA-01427 clicking on a view in the navigator

Category:DefaultRelease time:2015-10-11Views:130

SQLDev: Java: 1.6.0_04 Oracle: I'm getting the following error when I click on a view in the navigator pane: An error was encountered performing the requested operation: ORA-01427: single-row subquery returns more than one row 0[More]

Using database-link in view to get around ORA-01031 error

Category:DefaultRelease time:2015-10-11Views:130

I have been granted select rights on a users table. I am therefore able to select from his table. If however I try create a view against his table I run into the ORA-01031 problem. I have worked around this problem by creating a database-link to myse[More]

Getting ora:00904 invalid indentifier error while running i query

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a remote database and local database both are oracle 10gR2.Now i have written the below mentioned query in my local database and is working fine,but in case remote database it is throughing error ora:00904 invalid indentifier. I had export[More]

'ORA-01722: Invalid Number' error while Running a Query

Category:DefaultRelease time:2015-10-11Views:130

Hi, I'm trying to run a query built on a DSO. The DSO has a field 'Start Date'. This Start Date InfoObject has a reference Char as 0DATE. This Start Field has blank values due to which I'm getting the ORA-01722 error. I came across many threads with[More]

ORA-12712 error while changing nls character set to AL32UTF8

Category:DefaultRelease time:2015-10-11Views:130

Hi, It is strongly recommend to use database character set AL32UTF8 when ever a database is going to used with our XML capabilities. The database character set in the installed DB is WE8MSWIN1252. For making use of XML DB features, I need to change i[More]

While updating a table i am getting ORA-00600 error.

Category:DefaultRelease time:2015-10-11Views:130

Hi all, While updating a table i am getting the following: **SQL Error: ORA-00600: internal error code, arguments: [qkebCreateConstantOpn1], [], [], [], [], [], [], [], [], [], [], []** **00600. 00000 - "internal error code, arguments: [%s], [%s], [%[More]

Error while adding Image: ORA-00001: unique constraint

Category:DefaultRelease time:2015-10-11Views:130

Dear all, I have an error while adding images to MDM I can´t explain. I want to add 7231 images. About 6983 run fine. The rest throws this error. Error: Service 'SRM_MDM_CATALOG', Schema 'SRMMDMCATALOG2_m000', ERROR CODE=1 ||| ORA-00001: unique const[More]

ORA-600 [17069] error while running catrelod.sql to downgrade 11g database

Category:DefaultRelease time:2015-10-11Views:130

Hi, We are downgrading our database to We have successfullly run catdwgrd.sql without any errors in 11g env. While running catrelod.sql in 10g env we are facing the following error: SQL> @?/rdbms/admin/catrelod.sql TIMESTAMP COMP_T[More]

Ora-00604,ora-01422 error while dropping the table

Category:DefaultRelease time:2015-10-11Views:130

Hi gurus, I am using Oracle 10g R2 on windows 2000 platform,while dropping the table the following error occured. ORA-00604 : error occurred at recursive sql level 1. ORA-01422: exact fetch returns more than requested number of rows. Need urgent help[More]

Ora-00600 error when dropping a table

Category:DefaultRelease time:2015-10-11Views:130

Oracle Database 11g Enterprise Edition Release - 64bit Production When I tried to drop a table, I got 600 error: SQL> desc DEV.ATTR_IDX$EX Name Null? Type NODE_ID NOT NULL NUMBER COL1 NUMBER SQL> show user; USER is "DEV" SQL>[More]

ORA-00600: internal error code, arguments: [ktsircinfo_num1]

Category:DefaultRelease time:2015-10-11Views:130

While taking export of a table received EXP error and while dropping/selecting the same gor ora-600 errors. . . exporting table TEST4 EXP-00003: no storage definition found for segment(29, 371385) SQL >Drop table test4 cascade; ORA-00600: internal er[More]

I can see this is a generic error message('Could not complete your request because of a program error.') and I have done my best to read through many of the responses. It occurs on the second, third, or sometimes fourth file that I try to 'Open', how [More]
My Wireless Router died last night, so I connected my PC Desktop directly to the Modem. It worked like a charm. I then decided to connect my MacBook Pro (2.4GHZ, OS X 10.5.3) to the Modem didn't work. I tried going into the network settings [More]
Yes, I'm trying to download something to without it automatically using itunes as default or the itunes symbol. I have gone to tools>options>applications and that doesn't seem to work. Even when it asks me what program to use and I choose winzip the [More]
Hi guys, I've done some research and it looks like the error I'm running into (when saving the web part properties) is that my post back is too large.  This is a simple sandbox web part I'm building, which works great until I added the last configura [More]
Not quite sure if this is the right place for this question but I'll give it a shot... I've recently got a new laptop and haven't yet plugged my iPod into it yet as I'm wary about losing all my app data. I've tried searching the internet but I haven' [More]
Hi, We have to do some validation on Header, Operation and Relationship of any work order (IW31, IW32). We have checked that validations can be done at BADI WORKORDER_UPDATE in the method u2018AT_SAVEu2019.  But user wants us to take the Cursor back [More]
Hi, I have a requirement to build a web page which is like a Questionnaire page. There are multiple questions and each question can have multiple acceptable responses. The responses can be either an Input text/Check box/RadioGroup depending on the Qu [More]
Can not open a PDF attachment in Google or Outlook. Help???Adobe's troubleshooting tips for problems with PDFs in the browser: [More]
hi  I have a w520 with a quadro 1000m graphics card running on windows 7 - im trying to get windows moviemaker to work but keep getting the message saying that my system isn't equipped to do this - ive downloaded the nvidea driver updates and also wi [More]
I just upgraded my iPod touch 1st gen to 1.1.4 to 2.1, and I also upgraded my iTunes to 8.0.1. When it was syncing, it gave me the error 13014. It would sync all the songs, videos, and apps, but it wouldn't sync the Genius feature, so I can't use tha [More]