No announcements
Found 253403 threads
-
0 Votes
Customer SQL Oracle source with 2 sql statements
Hello Miller , I do not have an Oracle instance to test it theory . Option 1 . You can use a Stored proc activity to ...Proposed | 2 Replies | 423 Views | Created by Miller NC - Tuesday, August 20, 2019 2:58 PM | Last reply by HimanshuSinha-msft - Friday, August 23, 2019 5:39 PM -
0 Votes
How to execute Unix scripts through SSIS?
Toolkit with SP execution command. 3) Use Execute process task to run batch file. Hope this will ...Answered | 2 Replies | 6246 Views | Created by Abhiyanta - Monday, April 18, 2011 5:56 AM | Last reply by Cpatil - Friday, April 22, 2011 7:41 PM -
0 Votes
Progress Bar and Store Procedure
with this progress bar control I want the application not hang when click button start and it execute the SP and show the progress to the progress bar control ...Answered | 1 Replies | 3702 Views | Created by zazamexico - Thursday, June 18, 2009 7:34 PM | Last reply by codevanced - Thursday, June 18, 2009 7:54 PM -
0 Votes
Branching the Control Flow on Oracle SP out parameter
Hello, I have a design question. I need to do the following at a control flow level: Execute Oracle store proc with a single ...Answered | 3 Replies | 2203 Views | Created by Andrew DV - Wednesday, March 28, 2012 7:42 PM | Last reply by Andrew DV - Thursday, March 29, 2012 12:31 PM -
0 Votes
SQL-Oracle MSDTC problem
be done via the Oracle stored procedures .. and it's the one that doesnt work and gives me an error that is unhelpful! Very much appreciate any ideas on how to ...Discussion | 1 Replies | 7270 Views | Created by Robbbbbbbbbbbbbbb - Tuesday, May 25, 2010 10:23 AM | Last reply by Dustin Metzgar - Thursday, May 27, 2010 6:17 PM -
2 Votes
Execute SQL Task via Oracle attunity connector
your sp doesnt return data aka a single exec, then i suggest defining regular OLEDB or ADO oracle connection and call by Execute SQL ...Answered | 4 Replies | 7658 Views | Created by zahranc - Sunday, May 27, 2012 5:47 AM | Last reply by NewCSharpUser - Thursday, March 20, 2014 1:28 AM -
0 Votes
how to export SP
hi everyone I want to export my sql server SP(stored procedure) to oracle I tried using Import / Export wizard but I doesn't execute ...Unanswered | 2 Replies | 3823 Views | Created by alman asif - Saturday, March 21, 2009 10:34 AM | Last reply by Madhu K Nair - Saturday, March 21, 2009 12:21 PM -
0 Votes
Oracle WCF adapter calling stored procedure owned by a different user
option. The user I am connecting to the db with has EXECUTE privileges and I can run the SP from a .NET command line app that uses ODP.NET. I ...Unanswered | 4 Replies | 7017 Views | Created by Greg Svitak - Monday, October 10, 2011 11:14 PM | Last reply by Greg Svitak - Tuesday, October 11, 2011 4:45 PM -
0 Votes
Excuting Stored Procedure in Sql 2005 using linked server with Oracle 10g under windows account is showing error 15274
I have a linked server connection from sql server 2005 (cluster) to Oracle 10g and i have the oracle drivers installed properly (using ORAOLEDB.ORACLE). I am trying to ...Unanswered | 2 Replies | 9749 Views | Created by KSaha - Tuesday, July 15, 2008 2:29 AM | Last reply by MarkGWS - Wednesday, December 3, 2008 3:52 PM -
0 Votes
SQL Agent service user login mapping issue to linked Oracle server
The box in question is a SQL Server 2000 SP4 Standard Edition on a Windows 2003 Server SP 2 box with Oracle 10.2.0 client tools installed. A linked server to an -
5 Votes
Execute Sp
Yes Sir it is not saved D:\\ Location. Actually it not script it is One SP i think We have to execute ...Answered | 19 Replies | 5129 Views | Created by subu999 - Thursday, October 20, 2011 9:38 AM | Last reply by subu999 - Thursday, October 27, 2011 1:43 PM -
0 Votes
Linked Server to Oracle / decimal place truncation
Hey guys, We're currently setting up a new production server with SQL Server 2014 SP 1 (old server: SQL Server 2008 R2). In both server we have a Linked ...Answered | 1 Replies | 2255 Views | Created by Manuel Bauer - Thursday, June 4, 2015 2:31 PM | Last reply by Olaf Helper - Thursday, June 4, 2015 2:42 PM -
0 Votes
oracle sp in a loop
Hi all, I'm executing a SP in Oracle via adapter pack with BTS2006. I have a loop to call the SP multiple times. If I call the SP 1 time ...Unanswered | 7 Replies | 11530 Views | Created by MSDNuser176 - Monday, March 23, 2009 11:30 PM | Last reply by Colin Meade - Tuesday, June 12, 2012 8:52 AM -
0 Votes
Reporting Services + Oracle Stored Procedure
this is how our sp is defined in oracle:Proposed | 2 Replies | 8209 Views | Created by Oscarfh - Wednesday, May 14, 2008 6:01 PM | Last reply by RisAdams - Tuesday, July 15, 2008 12:00 PM -
1 Votes
Oracle Polling issue: Can PostPollingStatement in BizTalk execute an Oracle store procedure?
I have this is the postpollingstatement: EXECUTE TEST and the sp TEST is listed below: create or replace TEST ...Answered | 5 Replies | 6166 Views | Created by FrankTo - Friday, June 10, 2011 3:08 PM | Last reply by FrankTo - Friday, June 10, 2011 5:20 PM -
0 Votes
execute sp as variable
I believe what you can do is to put the whole sp (with the var) in a string var, and then use exec (@sp) to execute it. Hope this helpsAnswered | 2 Replies | 368 Views | Created by arkiboys - Tuesday, August 16, 2016 7:58 AM | Last reply by Dennisc2 - Tuesday, August 16, 2016 8:31 AM -
0 Votes
Executing stored procedure with output parameter on On-premise Oracle Database getting "expression 'NULL' cannot be used as an assignment target" error
to Local Oracle Database using Logic Apps Oracle Connector and azure on-premise gateway (refer below URL) https://imgur.com/a/dsqfoiM 4) Select ...Unanswered | 3 Replies | 1451 Views | Created by Srini_R92 - Tuesday, January 29, 2019 12:36 PM | Last reply by Simon Clendon - Tuesday, March 26, 2019 7:59 PM -
0 Votes
execute sp
, As the error message says, you have to pass the values for the parameter when you execute the SP,like EXEC [dbo].[sp_AuditTrace] 'Here ...Answered | 3 Replies | 2490 Views | Created by subu999 - Monday, August 13, 2012 4:13 PM | Last reply by subu999 - Tuesday, August 14, 2012 4:31 AM -
0 Votes
Error while Calling Oracle Stored Procedure from SSIS !
Hi pals, I am facing problems while calling Oracle stored procedure which has no parameters. I have used Microsoft OLE DB provider for ...Unanswered | 2 Replies | 5980 Views | Created by Manuv - Wednesday, March 19, 2008 3:08 PM | Last reply by Manuv - Thursday, March 20, 2008 6:43 AM -
0 Votes
Execute an Oracle Package
I have a package in Oracle containing 3 procedures (DELETE..., SELECT..., UPDATE...) How do I execute the entire package in C# so the all 3 procedures are ...Answered | 1 Replies | 1515 Views | Created by Shayaan - Wednesday, October 9, 2013 9:26 PM | Last reply by davidbaxterbrowne - Wednesday, October 9, 2013 9:56 PM
No announcements