Menurut saya, %TYPE mengikutsertakan length dari suatu tipe data sedangkan
parameter dari suatu procedure tidak mengikutsertakan length.
Coba.
CREATE OR REPLACE PROCEDURE AUTHID CURRENT_USER "USP_DEPARTMENT_I"
(
name_in IN VARCHAR2)
AS
BEGIN
INSERT INTO DEPARTMENT
VALUES(
dept_seq.NEXTVAL,
name_in
);
END;
---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+
countries) for 2ยข/min or less.
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
