Stack Overflow
Stack Overflow

Questions tagged [out-parameters]

145 questions
0
votes
0 answers

How to call PL/SQL stored procedure with table of records output parameter using C#?

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'GET_STUDENTS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored I keep getting this error and I don't know what I am doing wrong. I've tried different…
Fearless Coder
  • 25
  • 1
  • 5
0
votes
0 answers

Calling OUT PARAMETER in MYSQL from VB6

I am trying to get a result back from a stored procedure. I found this thread and modify it slightly to my need. Here is my MYSQL Stored Procedure code : DROP PROCEDURE IF EXISTS `InsertList`; CREATE DEFINER = `root`@`localhost` PROCEDURE…
padjee
  • 125
  • 2
  • 12
0
votes
1 answer

Cant call pl-sql stored procedure with OUT Parameter oracletypes.cursor

I need some help to call a Oracle Stored Procedure in Groovy and receive a ResultSet by an Output Parameter. I can call stored procedure with output parameters of other data types, but for CURSOR I cannot find the way. "I'm always getting the error…
José Cruz
  • 35
  • 3
0
votes
1 answer

how to display result of two out parameters from procedure

Everything is OK if I have one out parameter in stored procedure. Now I would like to output two of them. Could you help me? What is wrong? CREATE OR REPLACE PROCEDURE PROC1(p_product_id IN products.product_id%TYPE, p_name OUT products.name%TYPE,…
Jawor
  • 13
  • 5
0
votes
1 answer

Perfomance Out parameter vs Out system ref cursor Oracle Procedure

I have a Procedure in oracle with 12 parameters 4 of them are sys ref cursor. I am replace one cursor from my procedure using 8 more out parameters. Will there be any performance enhancement if use out parameters instead of out ref cursor.
शेखर
  • 17,412
  • 13
  • 61
  • 117
0
votes
1 answer

Setting the out parameter in callable statement

I'm trying to run a stored procedure that returns a resultSet using oracle jdbc. The procedure is as follows. create or replace procedure display_players (rset OUT sys_refcursor) as Begin open rset for select * from player_data; End; / The java…
codepoetly
  • 17
  • 1
  • 6
0
votes
1 answer

getting wrong value of out param on mysql procedure

I created a procedure on mysql. Here's my sql. drop procedure if exists proc_serial_no; DELIMITER // CREATE PROCEDURE `proc_serial_no`(IN comp_code varchar(20), IN meat_rule_one varchar(20),OUT serial_no int) LANGUAGE SQL NOT DETERMINISTIC…
Synge
  • 1
  • 1
0
votes
1 answer

Why are my variables written over?

This is in Unreal Engine so does use some code from that, but this SHOULD be a standard C++ problem I am having from what I can tell hence why I am posting it here. I know little about pointers so have likely messed something up here. Writing an…
pingu2k4
  • 956
  • 2
  • 15
  • 31
0
votes
3 answers

MySql, .NET, Stored Procedures sharing the current date and time with the calling client

I'm writing a stored procedure to update a table: UPDATE st SET somedate = NOW(); The client of the SP must know the exact date and time generated by the NOW function. There are two options: 1) the client passes an input parameter (called _now) to…
vulkanino
  • 9,074
  • 7
  • 44
  • 71
0
votes
1 answer

Dapper - Stored procedure oracle doesn't return result, if more two OUT parameters

Can help me. I don't get result in My code? if I'm using Dapper. using(var connection = new OracleConnection("User ID=TEST;Password=TEST;data source=R_TEST")) { connection.Open(); var p = new…
Арсений Савин
  • 709
  • 5
  • 6
0
votes
0 answers

c# mysql-connector varchar output parameter

I have a mysql (v5.6.25 running on windows 8.1) stored proc which does the following: DELIMITER $$ CREATE PROCEDURE `usp_GetData`(IN param1 int, IN param2 datetime, IN param3 datetime, OUT outparam varchar(2054)) BEGIN SELECT things FROM stuff…
Neil
  • 3
  • 1
  • 6
0
votes
0 answers

Return multiple cursors in pl/sql

My application hits database to load different sections in UI homepage. All sections are dependent on one input. So I created a proc that returns all data in different cursors. Now count of cursor return is around 25. My question is: What is…
Nitesh
  • 490
  • 3
  • 6
  • 15
0
votes
1 answer

plpgsql - How to return out parameter and ref cursor from stored procedure?

I would like to implement paging in my application. I created stored procedure that returns number of records as output parameter and ref cursor- data itself (with limits and offsets) But as result-I'm getting -" function result type must be bigint…
Max Iakovliev
  • 173
  • 1
  • 2
  • 7
0
votes
1 answer

Discrepancy in result returned by the Jdbc method

I can't seem to figure out whats wrong with the code below. The method getSalaryAverageDepartment calls the PL/SQL procedure get_salary_average_dept belonging to the EMP_PGK package in the HR schema. public float getSalaryAverageDepartment(int…
Chiseled
  • 2,280
  • 8
  • 33
  • 59
0
votes
0 answers

multiple out parameters in web service in vb.net

I have written a WCF service using vb. The client, written by a third party in c# requires two out parameters. The service works correctly, but I have a problem with the out parameters. Searching SO I found the solution and I have been able to…
Stefano
  • 1
1 2 3
…
9
10