Oracle Tag Directory

Featured Oracle Questions

  • Link Oracle 10g with SQL Server problem

    I have created a link between our Oracle DB and SQL server db It was successfully created and I was able to select data from oracle table using SQL Server. Then I have created a view in SQL Server using this link to read from Oracle, the view was created: create view dah_test as ( SELECT count(*)...

    Kmadani35 pointsBadges:
  • Find text in a form in Oracle Forms 6i

    How to search particular text_item in a field having lot of data? How to put find button option in a form and how to write in that coding.

    Subbareddy5 pointsBadges:
  • FI – General Ledger – When do we use the F-06 Incoming Payments transactions directly in GL?

    When do you post the following Transactions directly in GL? F-06 - Incoming payments F-07 - Outgoing payments FBCJ - Cash Journal posting

    Cogb5 pointsBadges:
  • about vb 6.0

    how can you use the inputs in form 1 to the other forms? like for an example, you made a student's grading system and you want to see the average and remarks of the grades that you have input in that form to the other what will be the code by then?

    Keishme5 pointsBadges:
  • Where does Oracle automatic backup create the backup file?

    I have created one database through DBCA on Oracle 10.1.0.2.0 and choose automatic backup daily at 2 am. But I cannot see any backup that is done under Oracle flash recovery area. Does it create in any other place? No error message was found in alertlog. Any ideas?

    OracleATE190 pointsBadges:
  • Converting and deploying 6i Forms to Forms 10g

    I need to convert an application written in Forms 6i to Forms 10g. Recompiling the forms seems to be straight forward, but then what? I was told that I can no longer run the application in client-server mode. If that's true, then how do I run them? Is there a runtime with 10g? I feel like an idiot,...

    Herbiebill35 pointsBadges:
  • Access 2003 IIF Function?

    I have a form and a subform relating to vehicles. The subform has starting mileage, ending mileage and the purpose of the vehicle's use, one of which is oil change. I would like a text box on the main form to show the next oil change mileage which should be 4500 miles from the ending mileage of the...

    Hld111025 pointsBadges:
  • form10g error

    FRM-10142:The HTTP Listener is not running at port 8224. please restart the listener or check your runtime preferences

    Tundeawok5 pointsBadges:
  • Oracle Essbase multi dimential data retrieval

    Need to retrieve actual adn budget data by company business unit then by GL account using Essbase. Have been advised internally that Essbase gets confused with the dimensional (cross reference) request so will not retrieve the data. Does anyone out there have any idea what I am talking about and...

    LEK5 pointsBadges:
  • Migrate Oracle 9i to Oracle 10g

    kindly provide me with details steps, as i will upgrade over 50 servers. what i am doing in three sites: 1) build temp server with same version. 2) uninstall Application. 3) uninstall 9i. 4) dis-join domain. 5) install Oracle 10g. 6) join domain mandatory for my application. 7) install my...

    Smattar5 pointsBadges:
  • Vietnam Local Chart of Accounts

    The Vietnam local chart of accounts has different account numbers by functional area. Since we can only link one alternative account to the GL account, how do other companies handle this requirement? Do you set up multiple accounts for the same line item so they can be linked to the different...

    Inafelman25 pointsBadges:
  • Flash Recovery Area in Oracle 11g

    What is the easiest way to handle the flash recovery area in Oracle? I'm having to run an RMan job daily to delete obsolete backups so the flash recovery area does not get too full and then I have to run an operating system task to clean up the empty directories that get left behind after the...

    ITKE344,995 pointsBadges:
  • Using INSTEAD OF Views in Oracle Forms 6i

    I have a block in my forms which is based on a view. I have created an instead of trigger on this view tu update certain fields. I would like to update this view through a Forms. I have made the block and the field updatable, but it gives me the following message when I try to write something on...

    Ariadnedbka5 pointsBadges:
  • Can a command button macro run a make-table query with an auto-inputted parameter value?

    I want to run a make-table query with a parameter, using a command button click event on a form showing a single record. The parameter value needs to be inputted automatically using the value of a control in the current record of the same form. Can this be done with a macro event? If so, what does...

    Shdrc5 pointsBadges:
  • How many statutory charts can be linked to a primary operational chart?

    We have a situation where we would like to establish a common operational chart for all countries. However, each country, and even each product line within a country, may have its own statutory chart. Can we map multiple statutory charts (and even multiple accounts within each chart) to a single...

    SRMoscoe10 pointsBadges:
  • multi instances of the form and subform

    in order to create 40 different forms for my application, i created one form with subform with possibility to open many instances of it. However, the total in the subform isnt working in instances of the form but only on the original form. How to make the total on the subform work on every...

    Toli70 pointsBadges:
  • linking report to form by macro

    I have a report that various info including name is pulled off of a form. i want to be able to click on the name in the report and have it bring up that particular record in the form. i can click on the name and it brings up the first record, but i want it to go to the specific record that matches...

    Mjward755 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:
  • Sales Order Detail

    The F42199 file is enormous and never gets any deleted records. How do you purge old records - or close to get deleted records.

    Opkelly10 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