How to execute an Oracle Store Procedure

#1

What is the best way to execute an Oracle store procedure with a DTS package?

#2

Can you use an ExecuteSQL task and make sure it is pointing to the Oracle
connection ?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"LIZ" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

What is the best way to execute an Oracle store procedure with a DTS
package?

#3

Thanks for the suggestion however when executing package get error: ORA-0900: invalid SQL statement.
----- Allan Mitchell wrote: -----

Can you use an ExecuteSQL task and make sure it is pointing to the Oracle
connection ?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"LIZ" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

What is the best way to execute an Oracle store procedure with a DTS
package?

#4

And what is the statement you are using ?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Liz" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Thanks for the suggestion however when executing package get error:
ORA-0900: invalid SQL statement.
----- Allan Mitchell wrote: -----

Can you use an ExecuteSQL task and make sure it is pointing to the
Oracle
connection ?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"LIZ" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message
news:68291803-79F5-45F9-88D8-1D43A54748D4 (AT) microsoft (DOT) com...
What is the best way to execute an Oracle store procedure with a
DTS
package?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to execute an Oracle Store Procedure

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How to execute an Oracle Store Procedure - 12-09-2003 , 05:11 PM

Re: How to execute an Oracle Store Procedure - 12-10-2003 , 06:02 AM

Re: How to execute an Oracle Store Procedure - 12-10-2003 , 08:51 AM

Re: How to execute an Oracle Store Procedure - 12-11-2003 , 05:52 AM