CREATE OR REPLACE PROCEDURE UP_TEST (
R_USERID IN VARCHAR2
)
IS
V_FILE_A VARCHAR2(50)
BEGIN
SELECT FILED_A
INTO V_FILE_A
FROM AAA
WHERE ROWNUM<2;
DBMS_OUTPUT.PUT_LINE(V_FILE_A );
END;
/
EXECUTE UP_TEST('TEST');
-------------오류 내역 -------------------------
ORA-06550: line 1, column 9:
PLS-00905: object RENTCAR.UP_TEST is invalid
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
위치 :1 Line , 9 Column
-----------------------------------------------------------
Begin UP_TEST('TEST'); end;
마농님 말씀대로 했는데 오류 네요 ㅠㅠ