HELLO, ...

[gwoo09-blog]

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

[gwoo09-blog]

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

[gwoo09-blog]

“hello, world”

first text