• Losing SSIS database connection to Oracle

    Our SSIS package takes data from an Oracle view, transforms it and then loads it into a SQL Server table. Our database source / destination is all set (connected at least). But we keep getting this error message: Data Flow Task: ADO NET Destination has failed to acquire the connection...

    ITKE969,850 pointsBadges:
  • How to replicate database between two SQL Server databases with Oracle ESB middleware?

    I have two SQL Server databases with the same version. There is a Oracle bus service between the two SQL Server database. I want transaction replication between two database, two database located in different cities. How do I configure Transactional Replication between the two Database?

    RezaBavafa13635 pointsBadges:
  • How to store and retrieve images through BLOB in Oracle 10g database

    I'm using Oracle Forms 10g for that. Can you please help me step by step process? Is there any direct way to store bulk images in oracle 10g table as BLOB. If so I need to retrieve it to a form. While running the form it need to show the person's name with their corresponding photo.

    Deepika905 pointsBadges:
  • Changing career track for a DBA

    Hello, I am working in IT from last 6 years as an Oracle DBA. I worked in few small companies in my home town (home town is not a Oracle technology hub) to gain the experience as DBA and after I moved to metro and joined a big company as DBA. But due to some unavoidable family conditions I came...

    PranavPareek5 pointsBadges:
  • Transfer Oracle tables into DB2

    I need to access several Oracle tables and copy them into DB2. What's the best way to do that? Thanks so much.

    ITKE969,850 pointsBadges:
  • How to identify a column name based on value and table name provided in Oracle

    How do I identify a column name based on value and table name provided in Oracle?

    vikas855 pointsBadges:
  • Running Oracle Application 6i on Windows 8.1

    I have copy Oracle Developer 6i Folder from Windows XP to Windows 8.1 on laptop computer, and also, I have export Oracle from Windows XP and imported on Windows 8.1, so my application is working fine, but the report is not working ,the Reports Background Engine continue show the message working...

    MAY05659292714145 pointsBadges:
  • I go an issue on a DB where time to time a query return ORA-00942

    I activated the trace on the session but any time I did I got it work again. I'm running in Oracle 11g. I check the user, the right. What it is strange it may start working again. Any ideas?

    GBATLZ5 pointsBadges:
  • ssma_oracle.to_char_date

    ssma_oracle.to_char_date function was missing in the conversion. Do you have the code for the function?

    ayso2976005 pointsBadges:
  • Oracle 10g: How many rows were affected by PL/SQL update

    For Oracle 10g, I'm running a PL/SQL function that updates several rows. Is there a way for me to see how many rows were affected? I need this number in PL/SQL. Thank you.

    ITKE969,850 pointsBadges:
  • How to determine if field is null in PL/SQL or Oracle

    How can I tell if a field is null in Oracle - PL/SQL? I know how to do it using SQL Server, IsNull() but I'm struggling with this. Can anyone help?

    ITKE969,850 pointsBadges:
  • Oracle database: Query for listing schema names

    In my Oracle database, I have to delete several unused schemas. Does anyone know if there's a way I can query for all my schema names so I can do this? Thanks very much.

    ITKE969,850 pointsBadges:
  • IN PL/SQL how to declare and use ‘STATIC DATA TYPE like C’

    Hi All, Can anybody help me to declare a variable having the similar propery of 'STATIC DATA TYPE IN C'. Means declare a variable and initialize it inside the procedure and called the procedure recursively but each time it is initializing the variable. I want any mechanism in PL/SQL that will make...

    Oracle10g4developers5 pointsBadges:
  • How do I remove a filter in a report created using UNION

    Does anyone know how can I remove a filter in a report created using UNION?

    akaMzambo5 pointsBadges:
  • Is it possible to use ADDRDBDIRE to connect to Oracle database?

    Is it possible to connect to Oracle database from IBM i? How to do that (I have IP address user ID, password and SID)? Thank you.

    VadimR5 pointsBadges:
  • Slow connection to Oracle from AS/400 (OJDBC)

    I'm trying to connect to Oracle from AS/400 via OJDBC, but the connection is taking 30 seconds. The same is for connection to SQL Server. To connect MySQL is okay, it is simultaneously.

    migallego5 pointsBadges:
  • AIX 7 and ORACLE 11 Read CR/LF from database

    We have an Oracle 11 database with CR/LF in one of the table. We run query from two clients: AIX 5.3 with Oracle 9, we got the CR/LF. Second client - AIX 7.2 with Oracle 11, same query, the CR is deleted and we receive only LF.

    asherhaim5 pointsBadges:
  • Which is better: Oracle quality module or customized forms?

    Which is better and why in Oracle quality module or customized forms what are pro's and cons of each? If there's a scenario in which we would prefer one, how to we make the decision?

    sufi12315 pointsBadges:
  • How to update Oracle table with CSV file

    My CSV file has several columns. Now in my Oracle table, the ID automatically identifies a row. Is there for me to replace my values in that table with the CSV file values while keeping everything else the same? Would a SQL script work?

    ITKE969,850 pointsBadges:
  • Oracle Forms application behave as a web portal in a browser

    I am migrating an Oracle Forms 6i application to Forms 11g and I need it to: Scale as any web application with the browser Get the WMI title visible Expand to all the browser window Thanks in advance. Javier

    JavierG5 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