133 questions
0
votes
0
answers
90
views
Calling a MySQL parameterised stored procedure using VBS and ADODB returns unexpected random values in the OUT parameters [duplicate]
MySQL (v5.7.44). Classic ASP using VBS, ADODB.
Not a newbie, and hoping this is not because of developing bad habits over the years, but after 3 weeks of trying this and that, I'm hoping someone can ...
0
votes
1
answer
867
views
How to call a stored procedure in SQL Server with output parameter from Web API
I do not know how to upgrade this code to retrieve output parameter from a stored procedure. For example that parameter name is TransactionPassCorrectly (it is a return parameter for some calculation ...
- 15
1
vote
0
answers
94
views
Get message of Raiserror SQL or change value of output parameter
Using SQL Server, I'm executing a stored procedure that may sometimes throw a Raiserror and sometimes not. Now I tried to use the returned parameter for tests, but it is not passed
errCount=-1
query=&...
- 21
2
votes
1
answer
2k
views
Dapper - Get value of output parameter from stored procedure
Without using Dapper, this code returns the correct result of "true":
using(connection= new SqlConnection(connectionString))
{
using(var cmd = connection.CreateCommand())
{
...
- 5,108
0
votes
1
answer
1k
views
Retrieve output parameter(s) from a SQL Server stored procedure
Trying to run a MS SQL stored procedure that has an output parameter. I have followed documentation on how to do this, but when I run my code I get this error: SystemError: <class 'pyodbc.Error'>...
- 11
1
vote
1
answer
720
views
How to assign result of OUTPUT DELETED to an output parameter?
I have the following query that generates the next available bill of lading numbers.
ALTER PROCEDURE [dbo].[GetNextTruckBol]
@FacilityId INT,
@Count INT = 1
AS
BEGIN
SET NOCOUNT ON;
...
- 68.2k
0
votes
1
answer
289
views
Return scalar value from parameterized SQL statement using DB2 EF Core
In a class library targeting .NET 5.0, EntityFramework Core, I can use the following code to return a scalar value from parameterized SQL statement using EF Core for SQL Server:
public object ...
- 51
1
vote
2
answers
309
views
How can I prevent caller to my function from using the same pass-by-reference variable in C++?
I have a legacy interface that has a function with a signature that looks like the following:
int provide_values(int &x, int &y)
x and y are considered output parameters in this function. ...
- 5,659
0
votes
1
answer
176
views
Why do C++ regular expression functions use output parameters?
Output parameters in C++ are generally considered a code smell according to the core guidelines. Yet, we have such functions in the regular expressions library
template< class BidirIt,
...
4
votes
2
answers
14k
views
How to select stored procedure output parameters as a table in oracle sql developer
I have a procedure
create or replace PROCEDURE proc
(
p1 IN varchar2,
p2 IN varchar2,
p3 OUT varchar2
) AS
BEGIN
p3:= p1 || ' ' || p2
END proc
I call it by
Declare
P3 varchar(50);
Begin
...
- 191
1
vote
2
answers
891
views
Stored procedure with OUTPUT - Must declare the scalar variable
I'm writing a stored procedure that will be executed from C# to get data from database. Therefore I have to pass a GUID to this stored procedure and it should find data in table Contact or in the Lead ...
- 97
0
votes
1
answer
129
views
C# getting error calling stored procedure with an output variable, parameter not supplied
I'm calling a generalized method in C# that returns a string from an Azure SQL stored procedure with an output variable. The error is:
Procedure or function 'TableScriptGenerate' expects parameter '@...
- 1,504
0
votes
2
answers
366
views
"numeric or value error" on the output parameter of EF CORE call to Oracle11g
I followed all the online help I could get and come up with this:
Stored Procedure:
create or replace procedure proc_cmap_unit_test
(
param1 in varchar2
,tkn out varchar2
) as
begin
...
- 1,586
3
votes
1
answer
2k
views
Dapper with SQL Server output bigint parameter returns int32
I have the following C# code and a SQL Server stored procedure.
private static long GetTestBigintOutput(SqlConnection dbConn)
{
var sqlParams = new DynamicParameters();
sqlParams.Add("@...
0
votes
1
answer
148
views
Oracle data access output parameter mixed up
I am invoking an Oracle stored procedure witch contains 15 input parameters and 4 output parameters. Output parameters are set like this:
OracleParameter p_errn = cmd.Parameters.Add("pErrCode", ...
- 45
0
votes
2
answers
511
views
tsqlt testing an output parameter from a stored procedure
I have a stored procedure that I am trying test for the proper generation of an output parameter. I experimented with tsqlt.ExpectException, but that did not work. I instead am trying tsqlt....
- 13
0
votes
3
answers
1k
views
Unable to use output variables from a PowerShell script in the Override Parameters of a Resource Group deployment task in Azure DevOPS
I have a PowerShell script where I have multiple output variables generated with the following syntax :
Write-Host ("##vso[task.setvariable variable=appObjectId;issecret=false]"+$appObjectId)
In the ...
- 812
5
votes
1
answer
6k
views
sqlalchemy Stored Procedure with Output
I want to call a stored procedure and receive the output parameter in python. I am using sqlAlchemy and can use parameters but do not know how to have the output be read into a variable. I understand ...
- 93
0
votes
1
answer
2k
views
CURSOR with a stored procedure with OUTPUT parameters
I have to insert one record at a time into a table and then execute a stored procedure by passing output variables.
The insert part actually does do the this and I see two different records into the ...
- 826
2
votes
3
answers
2k
views
Getting out parameter of stored procedure with C# only works when I put a breakpoint in my code
I have database connection setup with Entity Framework. I've created multiple stored procedures and one of them has an output parameter that I need in my application.
Procedure in c# :
public ...
- 167
0
votes
0
answers
437
views
Return Table with Stored Procedure in PostgreSql?
How can I return table in Stored Procedure ? I can do it in function but I have inout parameters.So I can not create in function. What can I do this case ?
Iguess,It should be like for function :
...
- 21
0
votes
1
answer
2k
views
How to get output parameter values of a SQLCLR stored procedure?
I created a SQL Server database project (VS2017) and I added a SQLCLR C# stored procedure. It's declared like this:
public static void RequestServiceToEncryptPassword(byte[] param1, out int param2, ...
- 109
2
votes
2
answers
3k
views
How to call stored procedure in Entity Framework Core with input and output parameters using mysql
I am using ASP.net Core 2.2 with Entity Framework core 2.2.6 and Pomelo.EntityFrameworkCore.MySql 2.2.0 for connectivity with MySQL, I have a stored procedure which takes 3 input parameters and 1 ...
- 1,560
0
votes
0
answers
246
views
Loopback node mssql: how to setup remote method to use output param for stored procedure?
I am using loopback3 api for an app to create new users. My remote-method '/newUser' execs a stored procedure, but is failing to create the new user.
App Flow: create new user by running 3 stored ...
2
votes
0
answers
371
views
Executing dynamic SQL to execute Stored Proc and get resulting string
This is my stored procedure which is called every two mins by a SQL Job.
USE [MyDB]
GO
/****** Object: StoredProcedure [dbo].[usp_Process_Invoice_USPs] Script Date: 27/03/2019 11:39:01 ******/...
- 2,583
1
vote
2
answers
75
views
How can i get @rErr / Output Parameter value in c#?
I create a SQL stored procedure
create proc p1
(
@name1 nvarchar(50),
@rErr int OUTPUT
)
as
begin Transaction
insert into test (name1)
values (@name1)
if @name1 = 'n100'
Begin
...
- 21
0
votes
1
answer
305
views
MSTSQL: Can a SP return both an out param and a result set
I wish to know whether it's feasible to have a TSQL stored procedure return both a result set and the output parameter like so.
create procedure uspReadMyXmlInformation(@myXmlDoc xml, @myProductNum ...
- 24.3k
0
votes
1
answer
23
views
How to return output paramter in mysql store procedure
I want to return a output parameter from a store procedure.
I have written below query,but the output param is giving blank value
CREATE DEFINER=`root`@`%` PROCEDURE `GetVendorSpecificReport`(
...
- 825
3
votes
2
answers
7k
views
Laravel Model SQL Server: Get Output Parameters from Stored Procedure
I want to get the output parameter from my SQL Server stored procedure in the Model of my Laravel, The Stored Procedure is working perfectly in the SQL Server Management tool and also in NORMAL php ...
user8268874
2
votes
1
answer
873
views
Object cannot be cast from DBNull to other types in stored procedure with output parameter
I want to use a stored procedure using SQL Server in a C# application that returns an output parameter but after trying many different ways I haven't realized how to do this.
This procedure should ...
- 845
0
votes
1
answer
1k
views
Record set or output parameters in a stored procedure in SQL Server?
I'm working in a project for my university about security based on the design of a relational database, using SQL Server, and I'm currently working in stored procedures specifically.
After doing some ...
- 23
6
votes
3
answers
27k
views
Spring JDBCTemplate Stored Procedure with ResultSet and OutPut Parameter
I created a stored procedure which returns result rows and two output parameters.
I am unable to find any thing in spring from which i can get ResultSet and outPutParameters.
I want to achieve ...
- 103
1
vote
3
answers
1k
views
C# changes output parameter to invalid value and throws error
Using:
Visual Studio 2010
SQL Server 2012
I have a stored procedure, which inserts a new record in the DB and returns the new record ID as an output parameter. I ran the sp manually and it works.
If ...
- 301
0
votes
2
answers
237
views
Get rid of output parameters when returning a container
When returning a container, I always had to determine if I should use return value or use output parameter. If the performance matter, I chose the second option, otherwise I always chose the first ...
- 1,597
1
vote
1
answer
340
views
Write to output parameter with c#
In SQL Server, I can pass a value IN to a stored procedure output parameter, alter it, and then read it back:
CREATE PROCEDURE [dbo].[testSP]
@myOutputParam INT OUTPUT
AS
BEGIN
SELECT @...
- 4,475
0
votes
1
answer
772
views
What should be the DbType in case of oracle raw output parameter
I'm using C# .net 4.5.2 and working with oracle DB.
I'm calling a function that have RAW output parameter (pPF):
FUNCTION GET_ACCESS_CONTEXT(pTId IN NUMBER,
pUId ...
- 560
0
votes
2
answers
2k
views
C# & SQL Server stored procedures - can't get output parameter value, return value works
I would like to get a value of an output parameter of a stored procedure, but I'm getting +1 all the time. When obtaining a value by return everything's ok.
I managed to obtain a value of the output ...
0
votes
2
answers
917
views
how to call stored procedure in EF6 with output parameters
i have a stored procedure which returns a parameter containing string in it i don't know how to call it and get the output parameter to show on my view
ALTER PROCEDURE [dbo].[sp_test]
@room_type ...
- 25
-1
votes
1
answer
639
views
How to make an output parameter in Stored Procedure in my scenario?
I have a query, that will insert a data into my table, and it should return one value
My Stored Procedure
ALTER PROC FspCreateRequest
@RequestDescription nvarchar(200),
@CreatedBy varchar(30),
@...
- 2,571
0
votes
1
answer
506
views
Get raised exception from stored procedure as output variable
I am having problem in storing the exception raised from a stored procedure.
For example I am having two stored procedures P_Add And P_GetAdd.
P_Add returns an exception on divide by zero as shown,
...
- 105
2
votes
1
answer
553
views
Procedure or function 'sp256' expects parameter '@countcase', which was not supplied
Using SQL Server 2008.
Wanted to output a parameter (@countcase) from a stored procedure called sp256. But when I exec the stored procedure, an error shows up:
Procedure or function 'sp256' expects ...
- 23
3
votes
3
answers
1k
views
Output parameter of MySQL stored procedures via ADODB in MS Access (VBA) correct on one computer and random on another
I have tried (nearly) everything to isolate the problem, but I am lost.
I have an MS Access application that uses ADODB to interface to a local MySQL database. I copied it to a new computer, but now ...
- 103
1
vote
1
answer
44
views
Output issue in Macros?
I have the following C code:
#include <stdio.h>
int x = 2;
int f (int z) { int temp = x; x += 2*z; return temp; }
#define MIN(X,Y) ((X) < (Y) ? (X) : (Y)) /* side effects may cause error ...
- 29
0
votes
1
answer
196
views
Having trouble with OUTPUT paramaters in SP with sqlsrv (PHP)
Sorry for my poor english. Here's the problem: i'm trying to reciebe an ID in PHP from a table in sql server express 2014 via sqlsrv driver, an SP and a output parameter.
When i execute de SP and ...
2
votes
1
answer
950
views
Does ADODB fail on output parameters with optional input parameters?
I have a stored procedure in a SQL Server 2008 R2 database with an optional input parameter and an output parameter like this:
CREATE PROCEDURE [dbo].[spCreateTicket]
(
@TrackingCode varchar(25),
...
- 3,507
0
votes
1
answer
1k
views
C# ODB.NET Out parameter is always DBNull
I have a stored procedure within a package in Oracle SQL Server.
This procedure has input and output parameters. The procedure itself works and when executed in Oracle SQL Developer the output ...
- 336
1
vote
1
answer
58
views
Creating table with dynamic columns using the PIVOT command
I have the following TSQL that I have been trying, without luck, to do 2 things with:
convert Nulls to 0
output to a temporary table I can use for
other operations.
Part of the result is captured in ...
- 99
1
vote
2
answers
2k
views
SQL Server Output Parameter showing null value in EF C#
I have a below stored procedure with output parameter.
ALTER proc [dbo].[CRS_GetNewMessageCount]
@CaseId int,
@Type varchar(50),
@Location varchar(50),
@Count int out
as
begin
if @location='admin'
...
- 3,252
12
votes
6
answers
2k
views
T-SQL stored procedure - Detecting if a parameter is supplied as OUTPUT
Consider the following T-SQL code snippet:
CREATE PROC dbo.SquareNum(@i INT OUTPUT)
AS
BEGIN
SET @i = @i * @i
--SELECT @i
END
GO
DECLARE @a INT = 3, @b INT = 5
EXEC dbo.SquareNum @a OUTPUT
...
- 179
2
votes
2
answers
2k
views
Calling Stored Procedure with output parameters
This is MS Sql Server: I have wrapped the system stored procedure, sp_sequence_get_range, so that I can have it return with a simple select (I was not able to figure out how to deal with the OUTPUT ...
- 2,246