stored-procedures

Postgresql – Error calling procedure in posgres "No procedure matches the given name and argument types. You might need to add explicit type casts."

CREATE or replace PROCEDURE mytransactions (n_transactions_id VARCHAR, n_transaction_amount SMALLINT, n_transaction_date TIMESTAMP, n_Delivery_date Date, n_customer_id VARCHAR, n_product_id VARCHAR, n_store_id VARCHAR) LANGUAGE plpgsql AS $BODY$ BEGIN INSERT INTO transactions (transactions_id, transaction_amount, transaction_date, Delivery_date, customer_id, product_id, store_id) VALUES (n_transactions_id, n_transaction_amount, n_transaction_date, n_Delivery_date, n_customer_id,…

VIEW QUESTION

MySQL Stored Procedure Issue with Procedure Variables

I have this stored procedure DELIMITER $$ USE `testdb`$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `TestProcedure`( IN year_number YEAR, IN month_name VARCHAR(12), IN input_region VARCHAR(20) ) BEGIN DECLARE total_regions_count INT DEFAULT 0; ## Get Distinct Regions. SELECT total_regions_count = COUNT(DISTINCT region) FROM aws_cost…

VIEW QUESTION

I want to increase or decrease the amount of money in Total_Crédit which is in Credit_electrecité depending on the event to be done – Phpmyadmin

create PROCEDURE PR_Credit_Total( in newidpiece int, in newnpiece bigint, in newnop varchar(60), in newdateengagement date, in newdatefacture date, in newlocalité varchar(50), in newtournee int, in newnpolice bigint, in newservice varchar(20), in newmontant float, in newecheance varchar(7), in newcreated varchar(25), in…

VIEW QUESTION
Back To Top
Search