Questions tagged as 'stored-procedure'

Tagged questions
2
answers

how to call a mysql stored procedure from php with data from a form

<!DOCTYPE html> <?php include 'MenuNav.php'; ?> <html> <head> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="viewport" content="width=device-width, initial-scale=1"&...
asked by 10.08.2017 / 03:40
1
answer

Execute a User Defined Function (String_SPLIT) from a Stored Procedure. SQL SERVER

I have a table 'interviews' in SQL that stores, among others, NVARCHAR data in the column 'account_id', and data type NTEXT in the column 'answer' which is fed from a series of concatenated questions and answers divided by the symbol '|'. I...
asked by 22.05.2017 / 22:25
2
answers

Linq query does not respond after updating Stored Procedure in EntityFramework

I'm working with EntityFramework 6 , I have my model created (First DataBase) for quite some time. In my project I have some queries with LINQ and others (to optimize times) made with Stored Procedures (SP). It worked correctly until I n...
asked by 20.04.2017 / 17:22
1
answer

Error creating and executing stored procedure

I am trying to create a stored procedure which verifies all the projects in my database and gives me for each project a series of elements that I need. When trying to do this, the procedure bugs me with an error Must declare the scalar var...
asked by 24.04.2017 / 21:34
1
answer

Is it possible to execute a stored procedure with one click?

I have a store procedure in SQL and I would like to know what is the simplest way to execute it. This is a set of tables that must be updated once a year, but you will not opt for the JOB because the update date will never be the same. The id...
asked by 15.08.2016 / 16:59
1
answer

How to select only the first records of a ranking when there are several ranking groups from a procedure stored in MySQL?

I have the following procedure stored in MySQL, it works for me but nevertheless it brings me more records, I mean there are several records that coincide in almost all the fields except in the series and in the date, so I decided to order them...
asked by 18.08.2016 / 14:37
1
answer

Return All fields in the table (Function PostgreSql)

How can I make a postgresql function or stored procedure return all the columns of the table without having to specify them? I want to achieve the behavior of the Sql Server query Sp. With the code that I show, I get the error ERROR: la list...
asked by 01.04.2016 / 20:29
1
answer

Call Stored Procedure in Java with data type SYS_REFCURSOR as output

I'm running a console application in JAVA, where I need to run a Stored Procedure done in Oracle , the Stored Procedure has three input variables that are of data type String and two output ones, one of which is String type and the last is of...
asked by 03.03.2016 / 19:43
0
answers

Run stored procedure from iReport

I have an error running a stored procedure from iReport :    Error filling print ... Error executing SQL statement for: reportIngresoCuenta   net.sf.jasperreports.engine.JRException: Error executing SQL statement for: reportInGenecount   at...
asked by 24.12.2018 / 17:08
0
answers

Query does not return SQL Server result

I have a problem with the following query in an sp, before it was executed and I returned the value, now it just throws me Commands completed correctly. and not the The result of the query strong> I share the query: BEGIN --INICIO S...
asked by 11.12.2018 / 17:20