sql - Calling a stored procedure in Oracle with IN and OUT parameters - Stack Overflow

sql - Calling a stored procedure in Oracle with IN and OUT parameters - Stack Overflow

瀏覽:1117
日期:2025-04-26
I have this procedure: CREATE OR REPLACE PROCEDURE PROC1(invoicenr IN NUMBER, amnt OUT NUMBER) AS BEGIN SELECT AMOUNT INTO amnt FROM INVOICE WHERE INVOICE_NR = invoicenr; END; So when I run it l......看更多