Don't wanna be here? Send us removal request.
Text
Warning: Procedure created with compilation errors.
sqlplus에서 procedure를 생성할 때, Warning: Procedure created with compilation errors. 이와 같은 오류가 발생되면 ‘show error’로 에러를 파악할 수 있다.
SQL> SHOW ERROR Errors for PROCEDURE SAMPLE01:
LINE/COL ERROR -------- ----------------------------------------------------------------- 14/3 PL/SQL: SQL Statement ignored 14/17 PLS-00201: identifier 'V_DETP.DEPTNO' must be declared
0 notes
Text
SQL SETTING (LINESIZE, PAGESIZE)
◎ SQLPLUS COMMAND >> SQL>SET LINESIZE number >> SQL>SET PAGESIZE number
◎ PIX SETTING >> oracle\product\server\sqlplus\admin\glogin.sql SET LINESIZE number SET PAGESIZE number
◎ SHOW SETTING >> SQL>SHOW LINESIZE OR SHOW LINESI >> SQL>SHOW PAGESIZE OR SHOW PAGESI
0 notes