No announcements
Found 3311773 threads
-
0 VotesIs it possible to use in C#/oracle table variable as a parameter for procedures?
If you mean oracle stored procedure and you're passing a table variable into that then this question is about oracle products and hence ...Answered | 2 Replies | 2298 Views | Created by prasad_ch - Friday, September 4, 2015 10:23 AM | Last reply by Andy ONeill - Friday, September 4, 2015 10:47 AM
-
0 Votes
Passing parameters to a stored procedure
If you go with the latest suggestion, take a look at this great article explaining how to pass them from C# ...Answered | 4 Replies | 4154 Views | Created by Jona Tec - Tuesday, May 25, 2010 2:02 PM | Last reply by Naomi N - Tuesday, May 25, 2010 3:02 PM -
5 Votes
Is it possible to pass TABLE as the output parameter in stored procedure
EXEC procName syntax to capture the results as a table Is it possible to call a procedure inline like how you said?Answered | 6 Replies | 38199 Views | Created by luckyforu2006 - Tuesday, August 10, 2010 12:49 PM | Last reply by Erland Sommarskog - Saturday, March 1, 2014 1:18 PM -
0 Votes
Stored Procedure Comparing parameters passed in with Table values
Hi try using below line of code: create procedure update_user ( @id int, @name nvarchar(100), @type ...Answered | 6 Replies | 4430 Views | Created by David Gutter - Friday, January 4, 2013 10:41 AM | Last reply by eralper - Friday, January 4, 2013 12:24 PM -
1 Votes
Varbinary(max) parameters in Nested Stored Procedures by value or reference _Expand / Collapse
(A BLOB has to be a handle like a table when it is over some size.)Answered | 2 Replies | 899 Views | Created by rdelong - Wednesday, September 17, 2014 5:11 PM | Last reply by rdelong - Tuesday, September 23, 2014 4:38 PM -
0 Votes
how to pass a string parameter from sql server to Oracle stored procedure
PostID=1672517&SiteID=1 How to call an Oracle Stored Procedure from a Sql Server 2000 Stored Procedure using a Linked ...Answered | 3 Replies | 4565 Views | Created by Bing2008 - Tuesday, April 17, 2012 3:52 PM | Last reply by Bing2008 - Tuesday, April 17, 2012 5:20 PM -
0 Votes
How to pass a table as parameter of a stored procedure
I got an table: create table order (orderid int not null, ....)Answered | 3 Replies | 5987 Views | Created by Antony Lai - Thursday, April 15, 2010 2:28 PM | Last reply by TiborK - Saturday, April 17, 2010 5:29 PM -
6 Votes
How to pass multiple values as a parameter to a stored procedure?
It should match the schema of the stored procedure.Answered | 9 Replies | 5471 Views | Created by ank hit - Thursday, May 24, 2012 1:11 PM | Last reply by ank hit - Thursday, May 24, 2012 4:41 PM -
0 Votes
Passing a multi-valued Parameter to an Oracle Query in SSRS
Hi ITBobbyP, Per my understanding that you have create an Oracle Stored Procedure and you want to add an multiple value parameter to ...Answered | 1 Replies | 3077 Views | Created by ITBobbyP - Tuesday, April 28, 2015 9:12 PM | Last reply by Vicky_Liu - Wednesday, April 29, 2015 9:48 AM -
0 Votes
how to pass a table parameter to my stored procedure
In Visual Basic or C#: use DataTable.Answered | 4 Replies | 621 Views | Created by sesquipedalian - Monday, August 27, 2018 7:26 PM | Last reply by sesquipedalian - Thursday, September 6, 2018 2:42 PM -
0 Votes
Oracle ODBC Adapter: How to pass datetime parameter to stored procedure
The error message you are getting is mainly because you are passing wrong value (indeed value in wrong format) for the dateTime variable.Answered | 3 Replies | 13720 Views | Created by Olgana - Thursday, April 23, 2009 2:12 PM | Last reply by Manas G - Friday, April 24, 2009 10:02 AM -
17 Votes
Passing multi-value parameter in stored procedure ssrs
Looks like you need to redefine the parameter (input) in your stored procedure and the function to be larger.Answered | 13 Replies | 137288 Views | Created by spydy2011 - Monday, April 16, 2012 8:24 PM | Last reply by martinitram - Wednesday, March 29, 2017 8:33 AM -
2 Votes
How to store multiple rows in one table using a stored procedure and parameters?
Hi Randel, If you've writen a stored procedure which takes two parameters Product and QTY, the key part of your code to execute ...Answered | 6 Replies | 4499 Views | Created by randelramirez1 - Monday, February 13, 2012 7:30 AM | Last reply by Leo Liu - MSFT - Wednesday, February 15, 2012 9:52 AM -
1 Votes
Table nested in Table passing parameter
Hello, In Reorting Services, the nested report use the same dataset with main report.Answered | 2 Replies | 2651 Views | Created by Computermike - Monday, May 6, 2013 4:09 PM | Last reply by Fanny Liu - Tuesday, May 7, 2013 2:28 AM -
0 Votes
Table Parameter of Store Procedure Limitation
Just run the test and able to pass 10M records without issue.Answered | 2 Replies | 5528 Views | Created by TravelMan - Tuesday, May 31, 2011 2:31 PM | Last reply by TravelMan - Thursday, June 2, 2011 9:58 PM -
0 Votes
Passing Multiple Values to Stored Procedure as a parameter
But i am getting error when i am running the query as subquery returned more than 1 value...Answered | 2 Replies | 5209 Views | Created by Anji1407 - Tuesday, July 24, 2012 9:19 PM | Last reply by Murali_CHN - Wednesday, July 25, 2012 3:41 AM -
1 Votes
Passing a null value to a stored procedure
If the NULL value [sic] is passed to the stored procedure, it does not return any results.Answered | 7 Replies | 1081 Views | Created by system243trd - Monday, January 18, 2016 7:23 PM | Last reply by --CELKO-- - Tuesday, January 19, 2016 5:44 PM -
3 Votes
Multiple Table Value parameters and the stored procedures they ride in on...
You can pass your data tables into 1 stored procedure and insert data into all related tables at once.Answered | 9 Replies | 2846 Views | Created by DBchBm - Wednesday, January 16, 2013 3:07 PM | Last reply by DBchBm - Thursday, January 17, 2013 2:26 AM -
0 Votes
MULTIPLE VALUES PASSING TO STORED PROCEDURE
Hi Sathya, Thanks for your reply, do i need to change the stored procedure?Answered | 4 Replies | 1802 Views | Created by MustafaH - Monday, December 30, 2013 3:51 PM | Last reply by Shahfaisal Muhammed - Monday, December 30, 2013 5:33 PM -
4 Votes
How pass optional parameters to stored procedure ?
You stated in your title "how pass optional parameters to stored procedure", so I assumed you knew what they were.Answered | 3 Replies | 22063 Views | Created by Haansi - Thursday, April 23, 2009 4:34 PM | Last reply by David M Morton - Thursday, April 23, 2009 4:58 PM - Items 1 to 20 of 3311773 Next ›
No announcements
