• Oracle installation and migration between versions in Linux

    Hi Experts, I need some useful doc links or step by step procedure to perform oracle installation and migration in Linux environment I surfed thru net ,cud not find any good docs or pdf on this As i am new to explore this role,can any one provide me some useful related links

    Inprise610 pointsBadges:
  • Oracle SP syntax issues

    We have a linked server from SQL to Oracle and successfully ran Oracle stored procedures from SQL to insert data. I am attempting to run a different SP that returns data but can't seem to get the syntax correct. My call includes a couple of date fields as parameters and a cursor is returned. Are...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Executing Oracle stored procedure from SQL server

    Using a linked server I can't seem to execute an Oracle SP from SQL. The Oracle SP requires 5 parameters and returns a cursor to a record set. The error I get suggests a syntax issue. OLE DB provider "MSDAORA" for linked server "PASSRPT" returned message "Syntax error in {resultset...} ODBC...

    Fishman15 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:
  • 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:
  • Connectivity between Oracle BI Publisher and Microsoft Access

    I need to make a connection from BI Publisher to an MS Access database. Anyone can help me with the connect string and database driver class details for setting up a JDBC?

    Ms123115 pointsBadges:
  • Delphi application freezing on search

    We have a deplhi application running. Sometimes (NOT all the time) when the user selects a search criteria and enters the search field, the application freezes after displaying the results in the grid. The grid that displays the search result is of type TAdvStringGrid. Backend is Oracle.

    Archarish5 pointsBadges:
  • Changing BCP format file collation

    Hi All, I was wondering if it was possible to change the collation of the format file created by the BCP utility from CS to CI, than import the data? The reason I ask this is I want to import the data from one column to another column using a different collation using bulk insert. Thanks.

    Db23290 pointsBadges:
  • Oracle 10g will not download to my Vista client machine

    I have ThomsonTechnology Textbook Oracle 10g Database Administrator Implementation and Administration IBSN:-13 978-1-4188-3665-8. Oracle OTN website will not log on my Vista machine. I have been able to download Oracle 11g sucessfully.

    Twolittlehorses4me10 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:
  • Run a business rule on save Hyperion

    What are the rules for business rules to be run on save in a form?

    Mlholly5 pointsBadges:
  • Take print of a report from Oracle 10g Form

    how can i take print of report from Developer 10g Form.

    Zain5 pointsBadges:
  • Accessing AS/400 DB2 physical files with Java

    Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I am...

    GeethaNatarjan15 pointsBadges:
  • OMS user name

    i'm trying to reconfigure the OMS since i'm new in this company. and i don't have any previous data from the old DBA except the sys user ans password which is a sysdba user. i recreated sysman user and i'm trying to reconfigure Oracle Management server, (after trying all current user in vain) i'm...

    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:
  • Change user password for Oracle Internet Directory

    i have to change the user password cn=orcladmin for internet oracle directory how?

    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,875 pointsBadges:
  • “Oracle Client 11.1.0.6.0″ Installation stuck at 33%

    While installing oracle 11g client version of 11.1.0.6.0, I am unable to proceed. In "Oracle Universal Installer Window", the status of installation is stuck at 33% for many hours, it is not proceeding. Please Help

    Orashezan5 pointsBadges:
  • Extracting data from multiple tables in Oracle 9i

    I HAVE 18 TABLES AND I NEED TO EXTRACT DATA FROM THESE TABLES AND STORE IT IN A SINGLE TABLE..THE PROBLEM I S THAT THESE TABLES DO NOT HAVE ANY COMMON FEILDS AND A SINGLE PRIMARY KEY. PRESENCE OF REDUNDANT DATA IS VERY MUCH . HOW TO COME OUT WITH THIS. I AM USING ORACLE9I .

    Umrn15 pointsBadges:
  • OMS user name

    i'm trying to reconfigure the OMS since i'm new in this company. and i don't have any previous data from the old DBA except the sys user ans password which is a sysdba user. i recreated sysman user and i'm trying to reconfigure Oracle Management server, (after trying all current user in vain) i'm...

    Sous580 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