Working with Oracle

• Topics

  Started by

  Posts

  Last post

• SSIS parameters for execute sql task and oracle

  I am trying to pass parameters to in the Execute SQL Task for an Oracle query. I am running a query…

  coder_t2

  7 replies

  13 years, 1 month ago

  By: amir.mochtar

• Problems to transcript a Oracle SQL Script

  Hello together, i have problems to build a T-SQL script for MS SQL 2005, which should do the same l…

  franz.ladda

  12 replies

  13 years, 1 month ago

  By: amir.mochtar

• Oracle PL\SQL for a T-SQL Developer

  I know this is a really stupid question (given what I saw on the Oracle boards) but I am trying to …

  sbelche-760308

  12 replies

  13 years, 1 month ago

  By: clayton.mitchell

• getting data from oracle table to sql server table

  Hello, I want to read the data from a oracle db table into a sql server db table. I heard that this…

  Sachin Vaidya

  1 replies

  13 years, 2 months ago

  By: PaulB-TheOneAndOnly

• Linked server error while excuting SQL proc

  I have a linked server connection to Oracle from SQL server. I am calling Stored procedure from St…

  ItsMeSri

  1 replies

  13 years, 2 months ago

  By: Stupeo

• Ref Cursors

  Hi All, I have a question regarding the ref cursors. Why is it required to use a ref cursor to retu…

  ssc_san

  10 replies

  13 years, 2 months ago

  By: PaulB-TheOneAndOnly

• Data needs to be transfered from SQL Server 2005 to Oracle 10g

  I am having a table in SQL server 2005 database (64-bit enterprise edition & SP3). I am having…

  DBAsql-1046554

  14 replies

  13 years, 2 months ago

  By: Bruce W Cassidy

• Insert data through View using openquery on Linked Server fails

  Hi experts, I've got an oracle linked server. In my SQL Server 2008 R2 DB i've a view pointing to a…

  sqlTobi

  3 replies

  13 years, 3 months ago

  By: PaulB-TheOneAndOnly

• Pulling data from oracle, SSIS vs OPENQUERY

  I have an interesting scenario here, I can't find what the problem is I pull data from oracle every…

  Ryan Naude

  6 replies

  13 years, 3 months ago

  By: @DJ

• Error reading string from Oracle to MS SQL 2005

  Hi all. I have set up a connection that pull data from Oracle 10.2.0. It is no problem to transfer …

  @DJ

  7 replies

  13 years, 4 months ago

  By: Source-NH

• Connectivity of Oracle Server from Windows XP and Linux?

  Hello All We have Oracle installed on Server. There are 2 OS running in the 2 network lines namely …

  sherwincurt

  3 replies

  13 years, 5 months ago

  By: PaulB-TheOneAndOnly

• Date Variable in Oracle

  Hello, I need help to write the following query in Oracle. It seems straightforward, however, I am …

  touchmeknot

  6 replies

  13 years, 5 months ago

  By: Welsh Corgi

• Dataware House, Data mining and OLAP?

  Hello can any one tell me waht is mean by Dataware House, Data mining and OLAP?

  sherwincurt

  4 replies

  13 years, 5 months ago

  By: PaulB-TheOneAndOnly

• SSIS - Error on Date conversion

  HI all, i'm building a SSIS package to import data from Oracle 8 to sql 2005. I'm importing about 8…

  CS-1058423

  2 replies

  13 years, 5 months ago

  By: CS-1058423

• Oracle ODBC connection and 'Force Encryption' on SQL Server

  I've set up an Oracle Gateway server to connect my Oracle databases to my SQL Server databases but …

  SQLDCH

  3 replies

  13 years, 6 months ago

  By: dyun