• 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:
  • Oracle 10g Instance not starting Up

    Oracle 10g startup command from SQL Plus gives the following error: ORA-01034 : ORacle not available ORA-27101: shared memory realm does not exist

    Raj66615 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:
  • rep-002

    I am getting error "rep-002:Unable to retrieve a string from the report builder message file " while opening a existing report in Reports 9i...How to solve this?

    Yegneshv5 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:
  • Updating Microsoft SQL Server tables from Oracle generates error

    i am not able to update table in ms sql2000 from oracle . can u sugegstyour views on this . the error i got is ORA-00904: "NAME": invalid identifier.

    Balecha10 pointsBadges:
  • NUMBER IN A LIST

    I am trying to do an update statement with a where clause that has a number table column in a string list. The string when displayed is ####, ####, ####; with no quote marks. This is in a when-button-pressed trigger in a form. It appears to work when the list only has 1 number in it, but returns...

    Papalpha5 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