Questions tagged [out-parameters]
145 questions
1
vote
0 answers
XMLType out parameter and ODP.NET
I try using XMLType column in my table and ODP.NET.
any full sample source code using ODP.NET and XMLTYPE out parameter?
My procedure:
PROCEDURE GET_DATA_DEPLOY(pPROYECT IN VARCHAR2,
pETIQ IN VARCHAR2 DEFAULT NULL,
…
Kiquenet
- 14,494
- 35
- 148
- 243
1
vote
1 answer
How to create a C-language function returning two or more OUT parameters for postgresql?
I need to return two arrays of integers in a C-language function for postgresql. Afaik, the best way to return two arrays of integers in a postgresql function is to declare the function with OUT parameters. But how to return two output parameters in…
Pupkov-Zadnij
- 1,342
- 2
- 11
- 21
1
vote
1 answer
JDBC exception at getting decimal out parameter of stored procedure
I'm trying to get parameter from MYSQL procedure.
My proc:
CREATE PROCEDURE proc(someIn INT UNSIGNED,
anotherIn INT UNSIGNED,
OUT x DECIMAL(10,7),
OUT y DECIMAL(10,7))
My java…
Borodin.Mik
- 332
- 1
- 4
- 11
1
vote
1 answer
How can i create out parameters with RAISERROR in stored procedure?
How can i create out parameters with RAISERROR in MSSQL?
This id stored procedure for example:
BEGIN TRY
//OPERATION
END TRY
BEGIN CATCH
DECLARE @ErrorMessage NVARCHAR(4000);
DECLARE @ErrorSeverity INT;
DECLARE @ErrorState INT;
…
JohnMalcom
- 851
- 4
- 16
- 28
0
votes
1 answer
Stored Procedure Output parameter returns null
SqlParameter[] par1 = new SqlParameter[4];
par1[0] = new SqlParameter("@prefix", "TIN-CMP-");
par1[1] = new SqlParameter("@codeLength", "17");
par1[2] = new SqlParameter("@LastCode", "");
par1[3] = new SqlParameter("@retVal", SqlDbType.VarChar,…
Mox Shah
- 2,967
- 2
- 26
- 42
0
votes
1 answer
Out parameters in stored procedures (oracle database)
I used stored proceture in the Oracle. How can I use out parameteres of the SP in C# code?
I use the following code for it:
OracleSP
PROCEDURE TABMPWORKREQUEST_INS(INTWORKREQUEST_ IN NUMBER, VCWORKREQUESTNUMBER_ OUT VARCHAR2,
INTREQUESTEDBY_ IN…
Pouya
- 1,908
- 17
- 56
- 78
0
votes
2 answers
C# - Anonymous object as 'out' parameter?
I am trying to make an anonymous object an 'out' parameter.
This code compiles:
public T GenericTest(T Input)
{
return Input;
}
public void AnonymousObjectTest()
{
var AnonObj = new { Prop = "hello" };
var Str = GenericTest(AnonObj).Prop;
…
user3163495
- 2,425
- 2
- 26
- 43
0
votes
0 answers
How to convert a C# method that use an 'Out' parameter to Python
I am working with the Revit API and I have some trouble executing this piece of code. I am aware that 'out' parameters in C# are not respected in Python, so I am asking if there is any way to convert this method to Python code so it can be…
GSA
- 1
- 1
0
votes
2 answers
Why an Out Parameter can be left unassigned in projects targeting .NET Standard?
I tried the below code in a C# (ClassLibrary) project that targets .NET Standard 2.0 and it compiles successfully, meanwhile it gives an error in another project targeting .NET Core 3.1
private void SetOffset(out TimeSpan offset)
{
…
Ahmad Ibrahim
- 1,915
- 2
- 15
- 32
0
votes
0 answers
How to initialize static out-parameters
Sorry if this is a basic question. Basically, I'm implementing a class with a bunch of static (and unchanging) resources that will be shared by all instances. The static resources need to be initialized once by being passed as out parameters to…
user13366655
0
votes
1 answer
MySQL procedure call from trigger always returns null for out parameters
My stored procedure OUT parameter, always return a null value.
Here is sample Table, Trigger and Procedure code.
Table: test
Columns:
id - Int
status - enum(‘pass’, ‘fail’) (null is allowed)
Values in a table:
id | status
1 | null
Trigger:…
Krunal
- 77,632
- 48
- 245
- 261
0
votes
2 answers
how can return two string from a method separately without appending?
I have method that will receive a string input(with message & mode name) and the method will separate the string input in to two strings(1.message 2.mode name) according to separator.
but i need to return this separated two string at a time.please…
Vipin
- 4,718
- 12
- 54
- 81
0
votes
1 answer
Cannot declare a class instance to be assigned to as an out parameter of library function
My VB.NET script needs to use a library written in C#, specifically the Connect() method that has an out parameter that is a class.
The VB.NET code calling the library method looks like this:
Dim devInfo As…
DBedrenko
- 4,871
- 4
- 38
- 73
0
votes
1 answer
Tableau connecting to Teradata procedure with out parameters not showing
I need to save a few parameters into Teradata via Tableau, I created a Teradata procedure to do insertion but when I connect to the procedure in Tableau it kept on giving me error "xxxx stored procedure returned no result. bla bla".
In order to…
Ling
- 349
- 5
- 15
0
votes
0 answers
Grouping out parameters into a struct
I have a function with a large number of out parameters which currenly looks as
int do_some_foo(char **string_out, int *index_out, char **description_out, etc...);
So since out parameters may grow and currently already about 8 in total (some of…
St.Antario
- 26,175
- 41
- 130
- 318