Stack Overflow
Stack Overflow

Questions tagged [output-parameter]

output parameters allow stored procedures to return data to the calling code.

133 questions
0
votes
1 answer

PDO output parameter error

I am using this SP, am getting both the result when using mysql workbench. CREATE PROCEDURE SP(IN _start INT,IN _end INT,INOUT _count INT) BEGIN SET _count = (SELECT COUNT(*) FROM tbl); SET @qry = CONCAT('select * from tbl limit ', _start,…
Hary
  • 5,690
  • 7
  • 42
  • 79
0
votes
0 answers

How to get an output parameter value using sqlalchemy for a cx_Oracle stored procedure

I have the following query in which the final parameter (var_clob) is an output parameter. query = """ BEGIN p_post_grade( :pin_term, :pin_crn, :pin_student_id, :pin_instructor_id, :pin_grade, …
nrussell_cumulus
  • 11
  • 1
0
votes
1 answer

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: returned a result with an error set. Here is my…
Josh Sorensen
  • 11
  • 3
0
votes
1 answer

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 GetResult() { var context =…
Phil U
  • 51
  • 4
0
votes
1 answer

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, class Alloc, class CharT, class Traits > bool…
KHALED ISMAEEL
  • 1
  • 1
0
votes
2 answers

Is there any way to disregard a SQL stored procedure's output parameters?

I have a stored procedure that performs some processing and returns a bunch of output parameters. I want to call the stored procedure just for the processing, and don't really care about the output parameters. Is there any way to call the stored…
froadie
  • 79,995
  • 75
  • 166
  • 235
0
votes
1 answer

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 '@table', which was not supplied I'm passing the…
Velocedge
  • 1,222
  • 1
  • 11
  • 35
0
votes
2 answers

"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 select 'hello' into tkn from dual; …
Johnny Wu
  • 1,297
  • 15
  • 31
0
votes
1 answer

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", OracleDbType.Decimal, 10); …
Hodza Ndzaho
  • 45
  • 9
0
votes
2 answers

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.AssertEqualsTable. CREATE TABLE #actual (msg…
David
  • 13
  • 2
0
votes
3 answers

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 PowerShell task in Azure DevOPS, I have set the…
David GROSPELIER
  • 772
  • 1
  • 9
  • 35
0
votes
1 answer

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 destination table. But the stored procedure seems…
Data Engineer
  • 795
  • 16
  • 41
0
votes
0 answers

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 : CREATE or REPLACE FUNCTION public."test" (INOUT "x"…
İlyas Derse
  • 21
  • 6
0
votes
1 answer

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, out byte[] param3) I also have a Windows Forms…
TajniakOsz
  • 83
  • 1
  • 1
  • 9
0
votes
0 answers

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 procedures: usp_CreateUser, which returns the UserID…
Manny Lornu
  • 1
  • 1
1 2 3
…
8 9