1 DECLARE 2 CURSOR READ_CUSTOMER 3 (I_CITY OUT NUMBER, I_STATE VARCHAR2 := 'CA') 4 AS SELECT FIRSTNAME, LASTNAME 5 FROM CUSTOMER 6 WHERE CUST_ID = I_CITY AND STATE = I_STATE;
CREATE PROCEDURE DOES_SOMETHING
(P1 IN NUMBER, P2 IN DATE, P3 OUT DATE, P4 OUT NUMBER) AS....
(P1 OUT NUMBER, P2 IN OUT DATE, P3 IN DATE, P4 IN NUMBER) AS....
(P1 IN OUT NUMBER, P2 IN OUT DATE, P3 IN DATE, P4 IN NUMBER) AS....
(P1 IN NUMBER, P2 IN OUT DATE, P3 IN DATE, P4 IN NUMBER) AS.....
CREATE OR REPLACE PROCEDURE MY_NEW_CAR (I_MODEL IN VARCHAR2, O_PRICE OUT NUMBER, I_COLOR IN VARCHAR2 := 'WHITE' , I_YEAR IN NUMBER DEFAULT '2000', ) AS
MY_NEW_CAR('ROLLS ROYCE', V_PRICE, 'GOLD', '1999');
MY_NEW_CAR('ROLLS ROYCE', 'GOLD'=>I_COLOR, V_PRICE =>O_PRICE);
MY_NEW_CAR('GOLD'=>I_COLOR, '1999'=>I_YEAR, 'ROLLS ROYCE'=> I_MODEL);
MY_NEW_CAR('ROLLS ROYCE', 'GOLD', '1999', V_PRICE,=>O_PRICE);