Is it possible to show the output print of a called procedure on retool. My procedure works perfectly but instead of showing the else print it just says run successfully .
I'm assuming that by procedure you mean Query? Do you
return the data you want in your query? Could you share your query?
DELIMITER $$ CREATE PROCEDURE GetCustomerLevel( IN pCustomerNumber INT, OUT pCustomerLevel VARCHAR(20)) BEGIN DECLARE credit DECIMAL DEFAULT 0; SELECT creditLimit INTO credit FROM customers WHERE customerNumber = pCustomerNumber; IF credit > 50000 THEN SET pCustomerLevel = 'PLATINUM'; SELECT pCustomerLevel ; ELSE SET pCustomerLevel = 'NOT PLATINUM'; SELECT pCustomerLevel ; END IF; END$$ DELIMITER ;
I want to after print pCustomer level on retool, as a popup after running procedure. Procedure is on workbench am calling it on retool