• Packet Write Failure error in Oracle 8.1.5

    I am using Oracle 8.1.5 with MS Dot NET 2005 on Windows XP with service pack 2. When I am sending data through a stored procedure, it is giving the error of "TNS:12571 : packet write failure" but it’s adding record in table, but truncated data in some columns and no data in the rest of the...

    BrentSheets6,925 pointsBadges:
  • Oracle archive log mode

    I have two databases A & B. A is a production database and B is an exact cloned copy of A and both are in archive log mode. I copy archived logs of database A using UNIX FTP binary mode to database server B and manually applied those logs to database B to keep both databases in sync. When I use...

    BrentSheets6,925 pointsBadges:
  • Error when using SQL*Plus @@ command in SQL Navigator

    When I try to use the @@ SQL*Plus command in a script I get the message "ORA-00936: missing exppression!" when it reaches the line containing this command. I read the help and they say that the @@ command is admitted. I've tried the same script in Oracle Enterprise Manager...

    Imre5 pointsBadges:
  • Oracle Financials

    When logging in and getting the account locked after three attempts, it does not give me a message. Please does anyone know how I can set the message to prompt that the accoun is locked after three attempts

    Knowledge12345 pointsBadges:
  • Validation error in Oracle10g

    If I try creating additional listener. It will opt for my OS credential(system username and password) and each time I enter it, it will give me this error"Validation error" and followed by another error message "oracle executable manager stopped working and was closed". please what will I do? How...

    TUMUCH5 pointsBadges:
  • Invalid objects after upgrade from 8.1.7.4 to 10G

    for the following procedure within a package: PROCEDURE GET_ALL_REGIONS(rs_REGION_LIST OUT r_REGION_LIST, Vrc2_err_msg OUT VARCHAR) IS BEGIN OPEN rs_REGION_LIST FOR SELECT DISTINCT(PRS_REGION) INTO r_REGION_LIST FROM SET_PARISH_RFT; Vrc2_err_msg:=NULL; RETURN; EXCEPTION WHEN OTHERS THEN...

    DBAKim5 pointsBadges:
  • Oracle Forms 6i trying to read a list of numbers separated by a comma

    Hello, I have an Oracle Forms 6i form with a text field that I want users to be able to put in a list of numbers seperated by commas, eg 12345,67890,34567 etc. From this list, I want to be able to use the list of numbers in an IN statement such as: CURSOR c_policy IS SELECT pe.cust_no,pe.policy_no...

    Doofusdog5 pointsBadges:
  • Oracle + iSQL*Plus – PLS-00103: Encountered the symbol “GRANT”

    Hi, i am trying to create some new csdba users and assign some roles to them however i keep getting the following error message - 7/22 PLS-00103: Encountered the symbol "GRANT" when expecting one of the following: * & | - + / at mod remainder rem => .. <an expo nent (**)> || multiset this...

    Cazza8855 pointsBadges:
  • Get the following error when logging into SQLPlus – ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist

    When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I'm using Oracle 10g Personal Edition Also getting the following error when trying to connect to an oracle database via VS2008 ORA-12514: TNS:listener does...

    Oracle20005 pointsBadges:
  • Calling a report from a form

    Hello experts I hope you all are fine & enjoying good health. I am facing a problem after migration from oracle 6i to oracle 9i, I wonder if someone can help me in calling a report from a form. I have used RUN_REPORT_OBJECT instead of RUN_PRODUCT but I am getting error FRM-41214 unable to run...

    Rakh80 pointsBadges:
  • ORA-03113: end-of-file on communication channel

    I am running a database health report which consists of many SQLs against the data dictionary. Every SQL returns fine except one querying for chained/ migrated rows which takes a little more time, and I get the following: ERROR at line 1: ORA-03113: end-of-file on communication channel I am running...

    OracleATE190 pointsBadges:
  • PL/SQL error

    Hi Experts, I am getting the follwoing error ORA-08102: index key not found, obj# 141051, file 28, block 15245 (2) I tried rebuild on that specific obj id still error persist wat are the possible causes and how to overcome please guide me

    Inprise610 pointsBadges:
  • PL/SQL Insert

    Hi Experts, I am trying to do 2 INSERT stms on 2 tables consecutively n same transaction and my first insert is successful while doing the insert on second table which is completely carry same set of attibutes and values of 1st table + 1 additional static value attribute,it gives ORA :01400 error...

    Inprise610 pointsBadges:
  • PLS-00103: Encountered the symbol “E_PROD_REQ_ID_NOT_FOUND” when expecting one of the following:

    how can i resolve that error? when i compile the store proc....it compiled without any errors....but in a package its throwing error

    Roopak055 pointsBadges:
  • VB6 Oracle 10 Stored procedures with parameters

    I have a vb6 - RDO code that works ok with Oracle8, recently there was an upgrade to Oracle 10g enterprise. Now I get the error 40041 -> Object Collection: Couldn't find item indicated by text. 1110 lstrSQL = "{call Pyramid.Load_Tables(?, ?, 0)}" 1120 Set lrdoQ =...

    Hermes6835 pointsBadges:
  • Oracle9i Release 1.0.2.2.2a Application Server Install – Enterprise Edition

    I am installing the Forms and Reports Server component only first. But it hangs when it get to 100% and it is saying "Installing Oracle9i Application Server 1.0.2.2.2a" It hangs after prompting a blank command line and it seems it is trying to run something. Here is the last line on the...

    Stecjohn15 pointsBadges:
  • Forms not connecting to upgraded Oracle 8.1.7 database to Oracle 10g R1

    i have upgraded my oraCLE 8i database to 10R1 and am trying to connect my oracle 6i froms to it. After doing the connection when i try to log into the application it tells me that the password and the user name is incorrect. i have tried with a different user details but its not working. what might...

    020884480835 pointsBadges:
  • ORA-00600

    What is the solution to this ORA-00600:internal error code, arguements: [kksfbc_reparse_infinite_loop],[],[],[],[],[],[],[]

    Shoksy5 pointsBadges:
  • rep-51002

    hello i have problem when i need to run the report 10g via form builder 10g by using web.show_document ,the error rep-51002 appear how can i solve that please where i am using oracle database 10g and oracle developer suite 10g on the same pc under windows .. thanks

    Abosy5 pointsBadges:
  • Oracle, MySQL connectivity by HSODBC

    Hello, We have tried to connect with MySQL from Oracle 10g Rel.2 through HSODBC and getting the following error: ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from MYSQLDB Both MySQL...

    Shafiqurrahmanbappy5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following