In SQL * PLUS, the function / process call method: - Description: Key_barcode () is the built function, the parameter is m_no in char, sq in char, pt in char, nkey is the return value. - p_key_barcode () The established process, the parameter is m_no in char, sq in char, pt in char, maxkey in out number.1.variable nkey number; execute: nkey: = key_barcode ('99A99A', '03', 'L'); Set ServerOutput on; Execute DBMS_OUTPUT.PUT_LINE (: NKEY);
2.Set ServerOutput on; Execute DBMS_OUTPUT.PUT_LINE (Key_Barcode ('99A99A', '03', 'L'));
3.Variable Nkey Number; Call Key_barcode ('99A99A', '03', 'L') INTO: NKEY; - Process: Call Key_Barcode ('99A99A', '03', 'L') Note: Call belongs to SQL statements , Invalid in PL / SQL
4.Select Key_Barcode ('99A99A', '03', 'L') from Dual; Note: Insert, Update, DML statement of INSERT, UPDATE, DELETE, in the SELECT statement, if used: ORA-14551: Unable Perform a DML operation error in the query.
5. (Procedure) Variable Nkey Number; Execute P_key_barcode ('99A99A', '03', 'L',: NKEY);