Call or invoke a stored procedure
To invoke or execute the sample stored procedure
customer(),
you can use any of the following SQL query forms:TEST.TESTSCH(USR)=> CALL customer();
TEST.TESTSCH(USR)=> EXEC customer();
TEST.TESTSCH(USR)=> EXECUTE customer();
TEST.TESTSCH(USR)=> EXECUTE PROCEDURE customer();
TEST.TESTSCH(USR)=> SELECT customer();Any of these commands cause the procedure to output the following:
NOTICE: The customer name is alpha
CUSTOMER
----------
(1 row)