Questions tagged as 'procedure'

Tagged questions
3
answers

Firebird suspend function

What is the role of suspend in a procedure in Firebird?     
asked by 18.07.2014 / 23:12
2
answers

censor a word registered in a database

Is there a way to censor and replace a MySQL registered word with a procedure or trigger for example? The word in the case would be Flash House and need to be replaced by Old School .     
asked by 05.09.2017 / 03:52
1
answer

Catch Browser Information in MySQL Procedure

Is it possible to get browser information in a PROCEDURE via MySQL code? Without having to pick up via back-end code and pass as a parameter. That is, does MySQL have any function that returns information from the browser?     
asked by 16.02.2017 / 19:20
1
answer

Order by SQL Server in Procedure

Hello, I am in the following situation: I need to select the amount of care of people of some age groups and of those who are male and female. I have the following tables: cadastro (id, natendimento, data, sexo, fokfaixaetaria) and fa...
asked by 02.09.2015 / 21:31
1
answer

Error executing function in PL / SQL

Code CREATE OR REPLACE FUNCTION BuscaNome RETURN t_name IS t_name VARCHAR(20); BEGIN SELECT T.DS_TURMA INTO t_name FROM TURMA T WHERE T.CD_TURMA = 13; RETURN t_name; END; Error:    Error: PL / SQL: Compilation unit an...
asked by 22.01.2018 / 19:18
1
answer

Create procedure to adjust price according to conditions (SQL Server) [closed]

In a DB of a bookstore I need to create a procedure to readjust the price column according to the percentage and gender reported (using transaction control). How should I do it? create table livro ( liv_ID int not null constraint PKcod_li...
asked by 26.10.2016 / 23:43
1
answer

Problem in defining onClick in runtime with Pascal (Delphi / Lazarus)

I need to use procedure ClicaItem(Sender: TObject); in a OnClick created at run time by calling procedure CriaItem(nome:String); . However, in all my attempts, I could not assign item.OnClick to procedure ClicaIte...
asked by 27.03.2016 / 08:03
1
answer

Dynamic access oracle cursor column

I have a situation where I need to access the attributes of a cursor differently. I have a cursor that returns me a list of records, with columns like col_1, col_nova, col_teste (illustrative names). I loop this cursor to fit a return string....
asked by 06.07.2016 / 21:22
1
answer

How to return a value in a MySQL procedure

I have the following procedure: DELIMITER $$ CREATE PROCEDURE sp_CalculaVolume ( IN vReservatorioCodigo bigint, OUT Retorno decimal ) BEGIN Declare Formato int; Declare TipoReservatorio bigint; Declare retorno decimal;...
asked by 16.08.2018 / 15:35
2
answers

I need to relate two tables in order to bring me a result within the conditions I want

I'm using SQLSERVER Condition (What the result should return me) · Creation of the agenda. It is necessary to create the flow for creation of agenda and blocking to reserve the vacancies; When crossing data from two tables I need to alloca...
asked by 13.05.2018 / 02:28