|
|
||||||
|
#1
10-14-04, 06:07 PM
|
|
|
|
|
HI,
Trying to set a Global Variable using output from a stored procedure. I'm using a row value. The stored procedure variable is declared as varchar(200). The Global Variable is declared as type string. However, when I display the global variable from an ActiveX script the global variable is NOT set. Any ideas |
|
|
|
#2
10-14-04, 07:37 PM
|
|
|
|
|
Have a read through this article.
Global Variables and Stored Procedure Parameters (http://www.sqldts.com/Default.aspx?234) |
|
#3
10-14-04, 08:55 PM
|
|
|
|
|
I have it working. The problem is that I was using Raiserror and then
returning a message variable back to the DTS. The Raiserror keeps the output paramater from being mapped to the global variable. So I tried to check the return code from the stored procedure and if the return code = 1, I want to issue an raiserror so the DTS takes a different branch. However, it never executes the raiserror after mapping the global variable. Sounds like a BUG! "Allan Mitchell" wrote: [..] |
|
|
| Similar Threads | |
| SQL Server stored procedure output parameters. Hello. I'm having difficulty getting the value of output parameters from stored procedures on a SQL server. I understand that this just doesn't work with odbc so I've tried... |
|
| Stored Procedure with Output Parameters Hi all I'm tryng to use MSDAORA access in a Oracle 9 database. I have a stored procedure named TEST with this Sign : PROCEDURE TEST ( PC_01 IN VARCHAR2 ,PC_02... |
|
| Using Stored Procedure at sqlDataAdapters with output parameters declare @Count int select @Count = COUNT ( * ) FROM tblXUDUserShip select FirstName,SurName,@Count AS BankaSayisi FROM tblXUDUserShip I have a Stored Procedure Which... |
|
| Getting OUTPUT parameters from another stored procedure OK, here is what I have. Proc1 defines some variables within it, say one is @Amount1 and @Amount2. (These are not parameters passed to proc1, they are variables within... |
|
| Stored Procedure Output Parameters I have a Stored procedure in SQL, that works, when tested in SQL, with one input & several output parameters, as follows: CREATE PROCEDURE myProcedure @MyID int , @First... |
|
|
All times are GMT. The time now is 05:46 AM. | Privacy Policy
|
Output Parameters set by Stored procedure