Oracle Developer Release 6i

Oracle Developer Release 6i 1.1

...1...5...6 ORACLE DEVELOPER... 6...6...6 Oracle Developer...6...9...9... 10... 10...10...11...12... 13... 13... 13...14... 14 ORACLE DEVELOPER R6I... 14 R6i...15...15...15 R1.x R2.x...15 Net8...19 R6.0...19... 19... 20...20...20...20...20... 20 1

Oracle Developer Release 6i...21 PLL...21 Developer...21...23... 23... 23... 23...24 PL/SQL... 24 PL/SQL... 24 R1.x...24 OUT IN OUT R1.x...25 R1.x...26 TO_PLS_INTEGER R1.x...27 LENGTH R1.x...27 R1.x...27 RETURN R1.x...28 R1.x...29 PL/SQL... 30...30...33... 34 PL/SQL... 35 R1.x...35 R1.x...36 R1.x...37 R1.x...38 %ROWTYPE %TYPE R1.x R2.x...38 DBMS_* R1.x R2.x...40 PARAMLIST NULL R1.x...40... 40 DLL 16 R1.x...40 DLL R1.x R2.x...41 FORMS... 41 / R1.x...41 VBX 16 R1.x...41 2

R1.x...42 R1.x...42 R1.x...42 R1.x...43 R1.x R2.x...43 R1.x R2.x...43 R1.x R2.x R6.0...43 R1.x R2.x...43 CHAR(0) R1.x R2.x...43 DATETIME R1.x R2.x...44 R2.x...44 R1.x...44 R1.x R2.x...46 R1.x...46 FORMS... 46...47...48...50...51...51...52...53 Tlist NULL...53 NULL POST-CHANGE...54 REPORTS... 54...54... 55 Procedure Builder...55 Schema Builder...55 Project Builder...55 Query Builder...57...58... 58 PL/SQL R1.x R2.x...58 FORMS... 58 R1.x...58 3

Oracle Developer Release 6i R2.x...59 OCX R2.x...59 FMB FMT R1.x...60 MENU... 60 R1.x...60...61 4

Oracle Developer Oracle Developer 6i R6i Oracle Developer Oracle Developer/2000 6.0 Oracle Developer R1.x 1.2 1.3.2 1.5.1 1.6.1 Oracle Developer/2000 1.x R2.x 2.0 2.1 R6.x 6.0 6i Oracle Developer Web Web Forms Web Oracle Developer R6i 2000 7 24 2001 1 9 4.4.3 5

Oracle Developer Release 6i Oracle Developer R6i 16 Oracle Developer VBX R6i OCX Oracle Developer R6i 1. Oracle Developer Developer 6

R1.x R2.x R6.x Forms 45 50 60 Reports 25 30 60 Graphics 25 30 60 3.1.1 R6i 6.0.8 6.0.5 2. R1.x Forms Designer Reports Designer Designer R2.0 Form Builder Report Builder Builder R1.x R2.x R6.x Forms Forms Designer Form Builder Reports Reports Designer Report Builder Graphics Graphics Designer Graphics Builder 3.1.2 3. Windows Developer Builder Designer R1.x 16 32 16 R1.x R2.x R6.x Forms f45des32.exe f50des32.exe ifbld60.exe Reports r25des32.exe r30des32.exe rwbld60.exe Graphics g25des32.exe g30des32.exe gobld60.exe 3.1.3 Builder Designer Windows Developer Runtime 7

Oracle Developer Release 6i R1.x 16 32 16 R1.x R2.x R6.x Forms f45run32.exe f50run32.exe ifrun60.exe Reports r25run32.exe r30run32.exe rwrun60.exe Graphics g25run32.exe g30run32.exe gorun60.exe 3.1.4 Runtime 4. PL/SQL PL/SQL PL/SQL Developer PL/SQL Developer PL/SQL R1.x PL/SQL 1.1 R2.x PL/SQL 2.3 R6.x PL/SQL 8 3.1.5 Developer PL/SQL 5. SQL*Net Oracle Developer Oracle SQL*Net R6i Net8 SQL*Net Developer SQL*Net Developer SQL*Net R1.x R2.x SQL*Net 2.x R6.x Net 8 3.1.6 Developer SQL*Net 8

Oracle Developer R6i CPU Windows R6i CPU OS Pentium 128MB Windows95 98 NT Service Pack5 380MB PL/SQL PL/SQL 8 RDBMS Net 100MB R7.3.4 R8.0.4 R8.0.5 R8.0.6 R8.1.5 R8.1.6 Net8 3.1.7 R6i Oracle Developer R6i 9

Oracle Developer Release 6i Oracle Developer R6i 1. 2. Oracle Developer R6i 3. 4. 5. 6. 7. Oracle Developer - - - - 10

1. Oracle Developer 2. R6i Oracle7 Oracle8 Oracle8i R7.3.4 R8.0.4 R8.0.5 R8.0.6 R8.1.5 R8.1.6 Oracle Develoer R6i R6i R6i ORACLE_HOME Oracle8 8.0.6 Oracle 7/8/8i 3. Oracle Develoeper R6i R6i R6i R1.6.1 R6i ORACLE_HOME R2.1 R6i ORACLE_HOME R6.0 R6i ORACLE_HOME Oracle Developer/2000 R6i Oracle Developer 11

Oracle Developer Release 6i R6i ORACLE_HOME ORACLE_HOME R6i R6.0 R6i R6i fmx R6i R6.0 Patch4 Patch5a Patch6a R6i Patch5a Patch6a Patch7 R6i R6.0 Patch5a Patch6a R6.0 Patch7 R6.0 R6i R6i R6.0 R6i (1) R6i (2) (3) Patch5a R6.0 R6i 12

R6i 6 13

Oracle Developer Release 6i R6i 1. Developer.fmb.rdf.ogd.pll.mmb 2. Developer.fmx.rep.ogd.plx.mmx 3. fmrjaw.res.res 4. 32 Windows HKEY_LOCAL_MACHINE SOFTWARE ORACLE 16 Oracle Developer Oracle.ini PATH 5. Oracle Developer R6i R6i R6i 14

R6i 32 ORACLE R6i R6i ORACLE_HOME R6i ORACLE_HOME ORAWIN95 Windows 95 ORAWIN98 Windows 98 ORANT Windows NT 16 ORACLE ORAWIN Oracle Developer R6i R6i ORACLE_HOME R6i Oracle Developer 3.3.2 Oracle Developer R6i R6i 1. R6i CD-ROM CD-ROM 2. Oracle 3. R6i R6i R1.x R2.x Oracle Developer R6i R6i R1.x R2.x R6.0 4.2.6 R6.0 1. R6i CD-ROM CD-ROM 2. Oracle 3. Oracle DEFAULT_HOME 15

Oracle Developer Release 6i 4.2.1 Oracle 4. Oracle Tools Oracle Forms Developer 4.2.2 Oracle Tools 5. 4.2.3 16

6. Software Asset Manager 7. Oracle Developer Tools Utilities GUI Common Files Required Support Files 4.2.4 Software Asset Manager 8. 17

Oracle Developer Release 6i 4.2.5 9. 10. Oracle 4.2.6 18

11. Oracle 12. R6i R6i Net8 R1.x R2.x SQL*Net R6.x Net8 Net8 1. $ORACLE_HOME network admin tnsnames.ora Developer 2. $ORACLE_HOME net80 admin tnsnames.ora 3. 4. sqlnet.ora 5. SQL*Plus80 R6i tnsnames.ora R6.0 R6.0 Oracle Oracle Developer Developer 19

Oracle Developer Release 6i Oracle Developer FORMS60_PATH REPORTS60_PATH PATH 3.1.1 TKxx_ICON R6i UI_ICON R6i Oracle Terminal R6i fmrjaw.res Windows $ORACLE_HOME FORMS60 Oracle Developer R6i 20

R6i R1.x R2.x 1. PLL 2. Developer PLL PL/SQL PL/SQL PL/SQL 1. PL/SQL 6 2. Builder < > < > PLL 3. Developer.fmb.rdf.mmb Developer PL/SQL PL/SQL 6 1. PL/SQL 6 2. Forms Reports Builder < > < > 21

Oracle Developer Release 6i < > Graphics Builder < > < > 3. 4. Reports REP Graphics OGR Form Builder Report Builder Graphics Builder < > < > < > < > < > < > < > < > < > 22

23

Oracle Developer Release 6i Oracle Developer R6i Rx.x PL/SQL R6i PL/SQL 8 R1.x R2.x PL/SQL PL/SQL 8 R6i PL/SQL PL/SQL PL/SQL R1.x R.2.x PL/SQL 2 PL/SQL 8 PL/SQL 8 PL/SQL 2 PL/SQL 8 PL/SQL 2 PL/SQL 8 PL/SQL 2 Oracle8 Server 6 PL/SQL PL/SQL R1.x PL/SQL 1 CHAR VARCHAR2 24

PL/SQL 2 CHAR PL/SQL 1 'hello' var1 CHAR(10) := 'hello'; PL/SQL 2 'hello '( 10 ) CHAR PL/SQL 1 CHAR(n) VARCHAR2(n) var1 VARCHAR2(10) PL/SQL 2 CHAR VARCHAR2 VARCHAR2 : 215 1..32767 VARCHAR VARCHAR2 PL/SQL 1 PL/SQL 8 CHAR(n) VARCHAR2(n) CHAR VARCHAR2(1) VARCHAR VARCHAR2(1) VARCHAR2 VARCHAR2(1) OUT IN OUT R1.x PL/SQL 1 OUT IN OUT OUT IN OUT OUT IN OUT 25

Oracle Developer Release 6i : 230 OUT IN OUT OUT IN OUT PL/SQL 1 PROCEDURE p (p1 IN OUT NUMBER DEFAULT 25, PL/SQL 8 IS BEGIN END; p2 OUT NUMBER DEFAULT 16) PROCEDURE p (p1 IN OUT NUMBER, p2 OUT NUMBER) IS BEGIN END; R1.x PL/SQL 1 RETURN NULL PL/SQL 2 RETURN RETURN RETURN NULL RETURN PL/SQL : 503 RETUEN < > NULL RETURN IF a = b THEN RETURN; END IF; PL/SQL 1 PL/SQL 8 IF a = b THEN RETURN NULL; END IF; 26

TO_PLS_INTEGER R1.x PL/SQL TO_PLS_INTEGER PL/SQL 2 TO_PLS_INTEGER TO_NUMBER TO_PLS_INTEGER : 201 TO_PLS_INTEGER TO_PLS_INTEGER PROCEDURE foo IS v INTEGER; BEGIN PL/SQL 1 PL/SQL 8 v := TO_PLS_INTEGER(24); END; PROCEDURE foo IS v INTEGER; BEGIN v := TO_NUMBER(24); END; LENGTH R1.x PL/SQL 1 NULL LENGTH 0 PL/SQL 2 NULL LENGTH NULL LENGTH NVL LENGTH(NULL); PL/SQL 1 PL/SQL 8 NVL(LENGTH(NULL),0); R1.x PL/SQL 1 2 VARCHAR2 RECORD NULL PL/SQL VARCHAR2 PL/SQL 2 NULL PL/SQL 1 PL/SQL 27

Oracle Developer Release 6i NULL NULL TO_CHAR( ) NULL TO_NUMBER( ) NULL TO_DATE( ) NULL NOT NULL : 307 'P' PL/SQL 1 PACKAGE ps1 IS TYPE foo IS RECORD (id PLS_INTEGER); PROCEDURE p (a VARCHAR2); PROCEDURE p (a FOO); END; PL/SQL 8 PROCEDURE foo2 IS BEGIN ps1.p (NULL); END; PACKAGE ps1 IS TYPE foo IS RECORD (id PLS_INTEGER); PROCEDURE p (a VARCHAR2); PROCEDURE p (a FOO); END; PROCEDURE foo2 IS BEGIN ps1.p (TO_CHAR(NULL)); END; RETURN R1.x PL/SQL 1 RETURN PL/SQL 2 RETURN 28

PL/SQL 1 PL/SQL RETURN NULL RETURN PL/SQL 1 PL/SQL 8 FUNCTION noreturn (arg IN NUMBER) RETURN char IS BEGIN IF (arg > 100000) THEN ENDIF; END; FUNCTION noreturn (arg IN NUMBER) RETURN char IS BEGIN IF (arg > 100000) THEN ENDIF; RETURN NULL; END; R1.x PL/SQL 1 BOOLEAN DATE PL/SQL 2 BOOLEAN DATE PL/SQL 1 PL/SQL 8 BOOLEAN(n) DATE(n) BOOLEAN DATE PL/SQL 2 MLSLABEL ROWID PL/SQL 8 PL/SQL 2 PL/SQL 8 29

Oracle Developer Release 6i MLSLABEL(n) ROWID(n) MLSLABEL ROWID PL/SQL PL/SQL Builder.plg R6i Buider Forms Reports Graphics Procedure Builder PL/SQL 8 PL/SQL 30

6.3.1 PL/SQL PL/SQL 31

Oracle Developer Release 6i 6.3.2 PL/SQL CHAR VARCHAR2 6.2.1 6.2.1 OUT IN 6.2.2 OUT IN OUT OUT 6.2.3 6.2.4 TO_PLS_INTEGER LENGTH 6.2.5 LENGTH NULL NULL 6.2.6 RETURN 6.2.7 RETURN 32

OK 6.3.3 PL/SQL Forms Reports PL/SQL Graphics 6.2 PL/SQL Forms 33

Oracle Developer Release 6i >ifcmp60 module=< > userid=< > upgrade_plsql=yes batch=yes >ifcmp60 module=old.fmb userid=scott/tiger@orcl upgrade_plsql=yes batch=yes Reports >rwcon60 source=< > userid=< > upgrade_plsql=yes batch=yes >rwcon60 source=old.rdf userid=scott/tiger@orcl upgrade_plsql=yes batch=yes PL/SQL.plg $ORACLE_HOME forms60 PL/SQL V1 - : MODULE1 WHEN-VALIDATE-ITEM (BLOCK.NAME) : LENGTH(...) NVL(LENGTH(...), 0) ( : 5 : 7) --- NEW_ITEM (Procedure Body) 34

SELECTION* (Procedure Body) ERROR 201 4, 27 : USER --- : CHAR VARCHAR2 ( : 2 : 5) --- : ( : 2 : 5) --- PL/SQL PL/SQL R1.x PL/SQL 1 PL/SQL PL/SQL 2 : 305 ' ' PACKAGE BODY pk1 IS PROCEDURE foo IS BEGIN NULL; END; PROCEDURE foo IS BEGIN NULL; END; 35

Oracle Developer Release 6i END; PACKAGE BODY pk1 IS PROCEDURE foo IS BEGIN NULL; END; END; R1.x PL/SQL 1 PL/SQL 2 : 305 ' ' v1 v_v1 PACKAGE pk1 IS v1 PROCEDURE v1; NUMBER; PROCEDURE p2 (x OUT NUMBER); END; PACKAGE BODY pk1 IS PROCEDURE v1 IS 36

BEGIN. END; PROCEDURE p2 (x OUT NUMBER) IS BEGIN x := pk1.v1; END; END; PACKAGE pk1 IS v_v1 NUMBER; PROCEDURE v1; PROCEDURE p2 (x OUT NUMBER); END; PACKAGE BODY pk1 IS PROCEDURE v1 IS BEGIN END; PROCEDURE p2 (x OUT NUMBER) IS BEGIN x := pk1.v_v1; END; END; R1.x Oracle Developer P1 Oracle Developer FLOOR PL/SQL 1 v := p1.floor(x); FLOOR PL/SQL 1 FLOOR PL/SQL 2.3 37

Oracle Developer Release 6i PL/SQL PL/SQL 2.3 : 302 : 'FLOOR' PL/SQL 8 v := FLOOR(X); : PL/SQL 1 Procedure Builder PL/SQL 2 Procedure Builder 2 $$ DEBUG DEBUG$$ R1.x PL/SQL 2.3 VARIANCE VALUE MAIL %ROWTYPE %TYPE R1.x R2.x PL/SQL 2 PL/SQL 8 PL/SQL 2 PROCEDURE < > (parameter IN < >) PROCEDURE < > RETURN (parameter IN < >.< >) 38

: 488 ' ' %ROWTYPE %TYPE PL/SQL8 PROCEDURE < > (parameter IN < >%ROWTYPE) PROCEDURE < > (parameter IN < >.< >%TYPE) RETURN 1 %ROWTYPE FUNCTION return_table RETURN dept IS FUNCTION return_table RETURN dept%rowtype IS 2 %TYPE FUNCTION return_column RETURN dept.dname IS FUNCTION return_column RETURN dept.dname%type IS 3 %TYPE FUNCTION return_parm (x IN NUMBER) RETURN x IS FUNCTION return_parm (x IN NUMBER) RETURN NUMBER IS 39

Oracle Developer Release 6i DBMS_* R1.x R2.x R6i DBMS_ PL/SQL DBMS_* PL/SQL DBMS_* R6i DBMS_* PL/SQL DBMS_* PARAMLIST NULL R1.x R1.x RUN_PRODUCT OPEN_FORM PARAMLIST NULL R2.x RUN_PRODUCT(REPORTS, 'filename', synchronous, runtime, filesystem, null, null); : 307 'RUN_PRODUCT' DECLARE plist PARAMLIST := NULL; BEGIN RUN_PRODUCT(REPORTS, 'filename', synchronous, runtime, filesystem, plist, null); END; Oracle Developer DLL 16 R1.x ORA_FFI 16 DLL Windows 16 32 40

16 DLL 32 DLL DLL R1.x R2.x DLL R6i DLL Forms Forms / R1.x R1.x 1 / R2.x PL/SQL.fmx 6.7.1 VBX 16 R1.x 16 R1.x VBX Windows 16 VBX 32 Windows 95/98/NT 41

Oracle Developer Release 6i 32 OCX/ActiveX R1.x R1.x R2.x 6.7.2 R1.x R1.x R2.x FRM-30436: R1.x R1.x R6i Forms 42

R1.x R1.x R2.x FORMS60_DEFAULTFONT R6i R6i R1.x R2.x 30 30 30 R1.x R2.x R6.0 CLEAR_LIST R6.0 FRM-41045: : ID R6i FRM-40105: < > FIND_ITEM ON-ERROR FRM-41045 FRM-40105 R1.x R2.x R6i 2,048 2,048 2,048 CHAR(0) R1.x R2.x CHAR(0) NULL R6i CHAR(0) 43

Oracle Developer Release 6i 0 DATETIME R1.x R2.x DATETIME R6i DD-MON-YY HH24:MI :SS R2.x R1.x R2.x R6.x R2.x R2.x R6i R2.x R6i R1.x R1.x R1.x DEFAULT CUSTOM R2.x DEFAULT R1.x DEFAULT 6.7.3 DEFAULT CUSTOM 6.7.4 44

6.7.3 DEFAULT 6.7.4 R6i R1.x < > 6.7.5 R6i 6.7.5 R6i 45

Oracle Developer Release 6i R1.x R2.x R6i R1.x R1.x R2.x R6i Forms R2.x R6.x R1.x 4.5 R1.x 5.0 R2.x R6.x 6.8.1 46

R2.x Tlist NULL NULL POST-CHANGE R1.x R1.x 1. A B GO_ITEM [Shift]+[Tab] PREVIOUS_ITEM A R2.x [Tab] NEXT_ITEM A A B [Tab] R2.x A 2. Forms Runtime 47

Oracle Developer Release 6i 1 Forms Runtime R2.x 3. NULL GO_ITEM [Tab] NEXT_ITEM R2.x FRM-40202 [Shift]+[Tab] PREVIOUS_ITEM R2.x FRM-40202 R1.x 1. NULL NULL Tlist NULL Tlist FRM-40212 48

FRM-40202 2. NULL 3. NULL 4. NULL 5. NULL 6. NULL POST-CHANGE 7. WHEN-VALIDATE-ITEM 3 5 2 49

Oracle Developer Release 6i 4.5 3 4.5 NULL WHEN-VALIDATE-ITEM NULL R1.x R2.x 4.5 4.5 A 5.0 C A D B B 1. A: NULL WHEN-VALIDATE-ITEM ITEM_IS_VALID PROPERTY_TRUE NULL 2. B: NULL NULL 3. C: NULL WHEN-VALIDATE-ITEM ITEM_IS_VALID 50

NULL Forms Runtime 4. D: NULL WHEN-VALIDATE-ITEM 3 A B C A B C A B C R1.x R2.x 1. ON- SEQUENCE-NUMBER 2. Tlist R1.x R2.x 1. RANGE_HIGH RANGE_LOW POST-CHANGE WHEN-VALIDATE-ITEM 51

Oracle Developer Release 6i 2. 3. Forms Runtime DATE DATETIME R2.x PL/SQL 1. RANGE_HIGH RANGE_LOW DATE DATETIME GET_ITEM_PROPERTY 2. DATABASE_VALUE DATE DATETIME GET_ITEM_PROPERTY Forms 4.5 Forms 4.5.7 3. CHAR DATE DATETIME 52

Forms 4.5 Forms 4.5.7 4. DATE DATETIME CHAR Forms 4.5 Forms 4.5.7 5. CHAR $$DATE$$ $$DATETIME$$ $$DBDATE $$DBDATETIME$$ Forms 4.5 Forms 4.5.7 6. Forms 4.5 SET_ITEM_PROPERTY ENABLED PROPERTY_FALSE REQUIRED PROPERTY_FALSE Tlist NULL Forms 4.5 Tlist NULL REQUIRED PROPERTY_TRUE NULL Forms Runtime FRM-40212: Tlist 53

Oracle Developer Release 6i NULL Forms 4.5 5.0 NULL NULL NULL Tlist NULL NULL NULL POST-CHANGE Forms 4.5 NULL POST-CHANGE NULL POST-CHANGE POST-CHANGE Reports Reports R1.x R2.x 54

R2.x Oracle Developer Forms Reports Graphics Procedure Builder Schema Builder Project Builder Query Builder Procedure Builder Schema Builder Project Builder Query Builder PL/SQL Oracle Developer Procedure Builder Procedure Builder PL/SQL.pll PL/SQL Schema Builder Schema Builder Schema Builder Project Builder Project Builder R6i Project Builder 55

Oracle Developer Release 6i R6i R6i 1. Project Builder 2. 3. 6.10.1 4. 5. R6i 6. 7. 8. R6i 9. R6i Project Builder 10. 56

6.10.2 11. 12. 13. 14. Query Builder Query Builder BRW QXF SQL R6i Query Builder 57

Oracle Developer Release 6i R6i Rx.x PL/SQL R1.x R2.x PL/SQL R6i PL/SQL PL/SQL 8 R6i PL/SQL 8 DECLARE TYPE test_rec IS RECORD ( a NUMBER := 0, b NUMBER := 31); TYPE test_tab IS TABLE OF test_rec INDEX BY BINARY_INTEGER; tab_tab test_tab; BEGIN tab_tab(1).b := 33; MESSAGE('A=' TO_CHAR(tab_tab(1).a) ' B=' TO_CHAR(tab_Tab(1).b)); END; R1.x R2.x A=0 B=33 R6.x A= B=33 Forms R1.x R1.x R6i 58

< > DML DML < > DML R2.x R2.x R6i R2.x 7.2.1 OCX R2.x OCX OCX OCX CANVAS CALL_FORM CALL_FORM ALERT MESSAGE OCX CANVAS 59

Oracle Developer Release 6i NULL FMB FMT R1.x Windows R1.x R6i.fmb.fmt Menu R1.x R1.x 50 R2.x 51 FRM-31649: : LABEL 50 60

Oracle Forms/Reports Developer Oracle Forms Developer and Oracle Reports Developer Oracle Reports Developer Oracle Reports Developer Oracle Developer 6i Upgrade Developer Forms 4.5 to Oracle Forms 6 http://technet.oracle.com/ 61