• Oracle Privilege error

    I am using Oracle 10g and does the following. Scheduling a job (procedure call) from my application. Procedure is querying synonyms of another schema and the schema is given the select privilege on all synonyms. When the procedure is executed directly, it works fine. But when scheduled as a job ,...

    Rajjo15 pointsBadges:
  • Oracle9i error message on installation

    while installing oracle9i in laptop i a getting message jrew.exe stoping program( i am using window vista

    Sajni10 pointsBadges:
  • ora-01033 oracle initialization or shutdown in progress

    ora-01033 oracle initialization or shutdown in progress what is solution

    0801705 pointsBadges:
  • Oracle 8i – SP2-0642 Internal Error

    I have installed Oracle 8i in Windows 2000 Server, but after connecting through as system/manager, I am getting SP2-0642 Internal Error. It is continuously running. Can you help me? Thank you. Moderator Note: This is a submitted question

    BrentSheets6,925 pointsBadges:
  • Oracle Report Builder 6i

    preprinted report can't allow to change any frame size...gives debug, dnt debug,cancle window. error soughts in before report trigger.Report WIDTH/HEIGHT:132/66

    22915 pointsBadges:
  • Oracle remote login results in IPNAT.SYS error

    Attempts at remote login to Oracle database throws an IPNAT.SYS error. Is this a firewall issue with Windows Server 2003? Or is this Oracle configuration problem? What is the best secure way to handle an IPNAT.SYS error? Thank you. Moderator Note: This is a submitted question.

    BrentSheets6,925 pointsBadges:
  • Error ORA 06550

    Hi.. I am Planning to make email automation . mail should have attachment. Attachment is the result of query execution in oracle database .I am getting error ORA 06550 and PLS 00013.Can u help me solve this glitch..Here I Put My PACKAGE.. create table config2 ( TO_ADDRESS VARCHAR2(1000),...

    Nidi915 pointsBadges:
  • ORA-01031 Insufficient privileges

    I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages

    SRDBA5 pointsBadges:
  • Oracle Forms 6i and Reports 6i

    i get an error message when i call a report6i from a form6i, plz tell me the whole code with description, and plz also send me an ebook related to form6i and report 6i

    Zaman31502110 pointsBadges:
  • SQL error

    DECLARE BEGIN FOR C1 IN (SELECT A.BANK,A.BRANCH,A.MODULE,A.SCHEME,A.ACCOUNTNO,A.ACCOUNTISN,NVL(T.NEXTDUEDATE,:TDATE) NEXTDUEDATE,A.REVIEWDATE FROM ACCOUNTMASTER A,TERMLOANSDATA T WHERE A.BANK=:INPBANK AND A.BRANCH=DECODE(:INPBRANCH,'ALL',A.BRANCH,:INPBRANCH) AND A.MODULE=:INPMODULE AND...

    Shindetanaji10 pointsBadges:
  • OracleOraHome92HTTPServer Stopped

    OracleOraHome92HTTPServer suddenly is not starting anymore, it is giving the below message: "Could not start the OracleOraHome92HTTPServer service on Local Computer. The service did not return an error. this could be an internal windows error or an internal service error. if the problem persists,...

    Sous580 pointsBadges:
  • Error message during Oracle installation

    when i install oracle appication service (portal,wireless,forms,reports) everything ok until cn=orcladmin password=.... a message error (error retrieving the oid administrator dn . please ensure that your oid connect inforation is correct) help pls ? thanks

    Army125 pointsBadges:
  • 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:

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following