Questions tagged as 'stored-procedure'

Tagged questions
0
answers

Stored Procedure codeigniter does not run

I have a problem calling a Stored Procedure with codeigniter, the stored is to generate an id autonumeric this is the code, I use PHP 7.0 , MySQL , Codeigniter 3 , jQuery 3.1 . DELIMITER $$ CREATE DEFINER='root'@'localh...
asked by 25.10.2018 / 22:22
0
answers

How to return two or more selects by a stored procedure and how to receive them in a dataset using c #

It turns out that I have a stored procedure where I return two selects, simply and simply like doing a SELECT * FROM [NombreTabla] , one below the other. I from C # what I do is receive it with a DataSet in the following way: var re...
asked by 24.10.2018 / 15:53
1
answer

Travel variable with a Store

I'm doing store procedure. But I have a doubt about the query that its results are two values. (@VarId) I need to pass the two values in the second query, so that I can return the data that is not found in the tb_change CREATE PROCEDU...
asked by 28.10.2018 / 18:59
1
answer

SQL stored procedure with variable filter quantity

I have a stored procedure with a table created by several inners, and what I need is to pass between 1 and 4 parameters to form the where of the query. What I'm not realizing is if I want to pass 2 of the 4 alone, that the others do not ask for...
asked by 11.10.2018 / 02:44
1
answer

Update all the records in a table using a sp

You have a table with column salary , and column bonus . The salary column has numeric data, the bonus column is a numeric type but it is empty. It is possible to create a stored procedure through which you can insert data to the whole b...
asked by 03.11.2018 / 00:44
2
answers

Problems when creating SP in Oracle

Good morning, I have a problem creating a stored procedure in Oracle and trying to save it tells me that I do not have privileges for the table to which I refer, but if I create the SP if I run the slect directly if it brings me re...
asked by 19.09.2018 / 23:11
1
answer

Problems with a procedure that grants permissions in a BD in MySQL

I am doing a procedure stored in MySQL that allows me to give certain permissions to the user that receives in the parameters, however, it does not assign them to the user that sent it by parameters when calling it, but, it creates a user with t...
asked by 18.09.2018 / 19:58
0
answers

rewriting Mysql fields or fields to null

I have a hosting in Godaddy of unlimited space with a MySQL database in MyISAM for my application. The bbdd has a weight of 280.4Mb and one of the tables contains 120713 records. For some time now some of these fields in this table are being...
asked by 14.09.2018 / 17:41
0
answers

Detect error in MySQLi query from PHP, using stored procedure

I have a question, I am developing a small PHP to obtain the data of a query in a procedure stored in MySQL, the problem is that I can not find a way to detect if this query ended in error, to perform the procedure if necessary corresponding in...
asked by 11.09.2018 / 02:26
1
answer

Problem in mysql stored procedure (Illegal mix of collations (utf8_unicode_ci, IMPLICIT) and (utf8_general_ci, IMPLICIT) for operation '=')

I have a stored procedure, which tries to validate that the user and the mail that is being entered does not exist in the database before creating the record (inserting them) in the database. The code I have is this: CREATE DEFINER='root'@'loc...
asked by 29.08.2018 / 02:35