View Complete Post
I have bunch of store procedures and each procedure is depend on previous procedure's return value.I am using Execute Sql task to call store procedure.I don't have any input parameters,just simple select statement.I want to save the return value from that
store procedure into variable and use that value to call another store procedure.
Can someone help on this...
Thanks in advance..
This is the sproc I am calling from my Asp.Net application:
ALTER PROCEDURE [Uds].[Dashboard_GetJobs2]
@date as datetime = null
Select * From Uds.RealtimeLogging
Where (@date is null or [timeStamp] > @date)
If I ran from query analyzer I get the correct results:
exec Uds.Dashboard_GetJobs2 '9/20/2010 11:01:23 PM'
However, if I ran the Asp.Net page, ALL records are showed. Looking at the SQL Profiler I see the following call:
exec sp_executesql N'exec Uds.Dashboard_GetJobs2',N'@date nvarchar(21)',@date=N'9/20/2010 11:01:23 PM'
And if I ran the statement above in query analyzer it WILL return ALL records. Why????
I will really appreciate if someone can post step by step process to call an Oracle Stored Proc from SSIS. Here is the Stored Proc Spec:
ÃÂ ÃÂ ÃÂ PROCEDURE Interface_Begin
ÃÂ ÃÂ ÃÂ (p_from_dttmÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ OUT varchar2,
ÃÂ ÃÂ ÃÂ ÃÂ p_error_codeÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ OUT number,
ÃÂ ÃÂ ÃÂ ÃÂ p_error_textÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ OUTÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ varchar2,
ÃÂ ÃÂ ÃÂ ÃÂ p_proc_nameÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ OUT varchar2);ÃÂ ÃÂ
I have a C# web page that calls a stored procedure. The page passes few parameters to the stored procedure and call it. The stored procedure does so many time consuming tasks on a huge number of database records but does not return any value.
Since the page is not expecting any return from the stored procedure, I want to execute the stored procedure asyncronously so that the user can continue working on the web page and other web pages while the stored procedure is running in the background. Also, I do not want the web server processes to be busy with the running stored procedure.
Any help, please.