Questions tagged as 'procedure'

Tagged questions
2
answers

Procedure execution with date type argument in a dblink

When executing the procedure below, via DBLINK in Oracle corporativo..UP_COP025_ASS_DMANDA_JURID_I 17444968, 1, "1", "20150806", "RJ", " ", " ", "000020" I get the error:    error: Syntax error during implicit conversion of VARCHAR value...
asked by 08.03.2016 / 13:54
1
answer

Subquery returned more than 1 value. This is not permitted when the subquery follows =,! =, = =

I have a procedure that sends email with the table data, including the email that will be forwarded, but it is sending to only the 1 record, the second it goes straight, and it's in Infinite Loop, sending multiple Emails to just the 1st r...
asked by 28.10.2015 / 14:35
1
answer

Oracle Store Procedure reading XML

I need to make a stored procedure that reads an XML file and writes to a table in my bank, but I have no idea how to do this ... Can anyone help me?  I have 2 hours to deliver this.     
asked by 05.12.2014 / 17:47
1
answer

Linear Regression SAS

I'm working on a project where I develop trend change indicators. One of them involves linear regression looking at 12 months, that is, I enter with 12 consecutive points from a time series and I want the thirteenth forecast. Behind some searche...
asked by 16.06.2014 / 03:29
1
answer

Call Function or Procedure Several Times

How to create a Function or Procedure that calls another Procedure to perform a neighborhood change in my ERP system? Follow the procedure below I want to set values for the parameters of it. It should be called based on a neighborhood table...
asked by 09.04.2014 / 22:05
1
answer

Procedure in MySql to clone products, using CURSOR FOR SELECT

I need to clone the data from a table EST_PROD_PRECO_CUSTO_EMPRESA of the company of id x to the same table but of the company with id and. in Pl / Sql I did it that way. DECLARE CURSOR v_precos IS SELECT ID_PRODUTO, PRECO_CUSTO, PRECO_CUST...
asked by 07.12.2018 / 19:29
0
answers

Error procedure holiday

Good afternoon guys, I'm trying to create a procedure and I can not solve my error even after several searches on the net, if you can help me, the error that appears is this: can not format message 13: 393 - message file C: \ WINDOWS \ firebi...
asked by 01.12.2018 / 18:28
0
answers

How to use the result of a procedure in another procedure?

I have the following procedure: DELIMITER $$ CREATE PROCEDURE retornaArvoresFeedback() BEGIN SELECT id, flagFeedback, prazoFeedback FROM arvore_classificacao WHERE flagFeedback <> 'null' AND prazoFeedback <> '...
asked by 13.11.2018 / 13:10
1
answer

Data from the same table for different Views?

I have found it difficult to solve the following problem: Assuming I have the following structure in the database: Id int identity primary key CodigoBanco char(3) Descricao varchar(100) Endereco varchar(300) Bairr...
asked by 25.10.2018 / 03:59
0
answers

Use cursor to update a MySQL table, based on a search

I would like some guidance on a challenge in MySQL 8. I have two tables: usuarios (id_user, nome, nascimento, endereço, cidade, ...) utilizacao (id_medicamento, nome, nascimento, medicamento, data, ...) The usuarios table stores all...
asked by 24.08.2018 / 15:20