Execute SQL problem with Oracle

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Elmer Miller (millere_at_empireco.nospam)
Date: 01/21/05 

Date: Thu, 20 Jan 2005 21:09:04 -0500

I have a strange problem that I am having trouble troubleshooting. I need to
execute a SQL commend against an Oracle database using DTS. I created a
'Microsoft ODBC Driver for Oracle' connection and based an 'Execute SQL'
task on that connection. When executing the task I get the "Multiple-step
OLE DB operation generated errors" message. The strange thing is that if I
go into properties of the Execute SQL task and click 'Build Query', I can
execute the query just fine in the query builder. Do you have any
suggestions on how I can troubleshoot this problem? Why does the query
builder work but the Execute SQL task doesn't. PS I also tried the
'Microsoft OLE DB Provider for Oracle' with the same results.
Any help would be appreciated. Thanks.

Relevant Pages

  • desc: invalid sql statement, answered
    ... It is not part of the Oracle SQL language. ... I believe a describe statement is Oracle DDL, but I still failed for both of the ways that I know of to execute sql. ...
    (perl.dbi.users)
  • How can I pass data into a boolean variable in SSIS from Oracle?
    ... In oracle, create a view that basically does something like this select * ... Then I create an EXECUTE SQL step in SSIS. ... of the SQL query. ...
    (microsoft.public.sqlserver.dts)
  • Re: Opinions on approach, please...
    ... Create a data layer program per table, ... number of bind variable tokens in your dynamic SQL. ... then simply EXECUTE that without passing it any parameters? ... Hard code WHERE clauses. ...
    (comp.lang.cobol)
  • Re: SQL Injection- Bypassing magic_quotes
    ... Because i was trying to execute: ... Don't terminate the query and you most ... Or try something like bobcat or one of the other SQL injection tools out ... Chief Information Security Officer ...
    (Pen-Test)
  • Re: Opinions on approach, please...
    ... Create a data layer program per table, ... number of bind variable tokens in your dynamic SQL. ... then simply EXECUTE that without passing it any parameters? ... explicitly code dummy words as bind variable placekeepers, put the host variables on the ...
    (comp.lang.cobol)