:Base de60.hlp :Title Procedure Builder Help System :Index Developer Built-in Packages=Pdpkg.HLP :Index Interpreter Commands=Pdincom.HLP :Index Forms Developer Demos=d2kdemo.hlp; :Index PL/SQL Language Reference=cplsref.hlp :Index Platform-Specific Information=d2kwin.hlp 1 Welcome! 2 Using the online help=usehelp>about 2 Documentation roadmap=Help_on_Help>about 1 New Features 2 Oracle8 object support in the Object Navigator=pnf_o8>newfeat 2 Type Wizard=pnf_typwiz>newfeat 2 Editing Oracle8 user-defined datatypes=pnf_metedi>newfeat 2 Improved editing features=pnf_codie>newfeat 2 Improved Database Trigger editor=pnf_dbtedi>newfeat 2 Syntax Palette=pnf_synpal>newfeat 2 EXEC_SQL built-in package=pnf_exesql>newfeat 2 New batch executable names=pnf_batexec>newfeat 2 Finding and replacing text in multiple program units=pnf_gsr>newfeat 2 Getting started with Procedure Builder=pnf_gs>newfeat :include o8nf.cnt 1 Building and Running a Program Unit 2 Creating and Editing a Program Unit 3 About Program Units 4 About PL/SQL program units=con_devpu>about 4 About program unit compilation=plc_compil>about 4 About program unit invalidation=plc_inva>about 4 About partitioning your application logic=plc_aplpart>about 4 About resolving cross references=plc_rrpu>about 3 Creating and Defining a Program Unit 4 Creating a program unit in the Program Unit editor=plc_uspue>howto 4 Creating a program unit in the Interpreter=plc_usint>howto 4 Importing an External Program Unit 5 About importing external program units=plc_impex>category 5 Loading a single program unit=plc_lod>howto 5 Running an Interpreter script=plc_intp>howto 5 Importing source text=plc_imput>howto 3 Editing a Program Unit 4 Editing a program unit=plc_edit>howto 4 Redefining a program unit=plc_redpu>howto 4 Calling a subprogram=plc_cspg>howto 4 Renaming a program unit=plc_renpu>howto 4 Finding and replacing text in a single program unit=plc_sch1>howto 4 Finding and replacing text in multiple program units=plc_schall>howto 4 Displaying program unit source=plc_dpus>howto 4 Viewing program unit information in the Object Navigator=plc_viewpun>howto 4 Displaying program unit information in the Interpreter=plc_viewpui>howto 3 Compiling a Program Unit 4 Compiling a single program unit=plc_comp1>howto 4 Compiling selected program units=plc_compsel>howto 4 Compiling all program units=plc_compall>howto 4 Compiling all uncompiled program units=plc_compun>howto 3 Saving or Deleting a Program Unit 4 Exporting a program unit to a text file=plc_expu>howto 4 Storing a program unit in the database=plc_spudb>howto 4 Deleting a program unit from the Object Navigator=plc_delpun>howto 4 Deleting a program unit from the Program Unit editor=plc_delpue>howto 2 Using a Stored PL/SQL Program Unit 3 About stored program units=plc_uspu>about 3 About name resolution for stored program units=plc_nmres>about 3 About privileges for stored program units=plc_priv>about 3 Calling a stored program unit=plc_calspu>howto 3 Using synonyms=plc_syn>howto 2 Testing and Debugging a Program Unit 3 Logging Interpreter Activity 4 About logging=con_logg>about 4 Beginning a new log file=log_begnu>howto 4 Appending logging to an existing file=log_app>howto 4 Disabling logging=log_disabl>howto 4 Enabling logging=log_enabl>howto 4 Viewing the log file=log_view>howto 4 Ending logging=log_stop>howto 3 About Debugging a Program Unit 4 About debug actions=dbg_ovu>category 4 About the call stack=dbg_calls>about 4 About debug levels=dbg_dlev>about 4 About the debugging process=dbg_cda>category 4 About server-side debugging=pnf_servdebug>about 3 Debugging a Program Unit 4 Displaying program unit source in the Interpreter=dbg_disps>howto 4 Creating a simple breakpoint=dbg_cbrk>howto 4 Creating a breakpoint with a trigger=dbg_cbrktg>howto 4 Creating a debug trigger=dbg_ctrg>howto 4 Running the program unit=dbg_run>howto 4 Examining and modifying simple variables and parameters=dbg_exam>howto 4 Examining and modifying complex variables and parameters=dbg_excomp>howto 4 Controlling suspended program unit execution=dbg_cpuex>howto 3 Managing Debug Actions 4 Viewing current debug actions=dbg_bda>howto 4 Disabling a debug action=dbg_eda>howto 4 Enabling a debug action=dbg_enada>howto 4 Deleting a debug action=dbg_rda>howto 3 Advanced Debugging Techniques 4 Setting a specific source location=dbg_setsl>howto 4 Examining or modifying variables with the Debug package=dbg_getxf>howto 4 Changing the current scope location=dbg_setsc>howto 2 Working with PL/SQL Libraries 3 About PL/SQL Libraries 4 About PL/SQL libraries=pll_libov>about 4 About library program unit invalidation=pll_puinv>about 3 Creating and Editing a Library 4 Creating a library=pll_cr8l>howto 4 Saving a library in the file system=pll_savlfs>howto 4 Saving a library in the database=pll_savldb>howto 4 Opening a library=pll_opn>howto 4 Adding a program unit to a library=pll_inspu>howto 4 Removing a program unit from a library=pll_rmpu>howto 4 Compiling library program units=pll_compu>howto 4 Closing a library=pll_cls>howto 3 Attaching or Detaching a Library 4 Attaching a library=pll_att>howto 4 Detaching a library=pll_det>howto 4 Loading program units from a library=pll_lodpu>howto 3 Managing a Library 4 Viewing library information=pll_vuinfo>howto 4 Renaming a library=pll_rena>howto 4 Granting and revoking access to a library=pll_graxs>howto 4 Deleting a library=pll_del>howto 2 Calling Functions in a Dynamic Library 3 About dynamic libraries=dyn_abt>about 3 About the foreign function interface=dyn_ffi>about 3 Initializing a foreign function=dyn_init>howto 3 Creating a PL/SQL interface to a foreign function=dyn_crpls>howto 3 Converting C types to PL/SQL=dyn_concp>howto 3 Examples of ORA_FFI=Ora_Ffi_example_1>examples 2 Running an Interpreter Script 3 About Interpreter scripts=scr_about>about 3 About program units in scripts=scr_pusin>about 3 Creating or editing a script=scr_crea>howto 3 Running a script in the Interpreter=scr_runin>howto 3 Running a script in batch mode=scr_runbt>howto 2 Creating and Editing a Database Trigger 3 About database triggers=dbt_about>about 3 Creating a database trigger=dbt_crea>howto 3 Editing a database trigger=dbt_edit>howto 3 Disabling a database trigger=dbt_disable>howto 3 Enabling a database trigger=dbt_enable>howto 3 Deleting a database trigger=dbt_drop>howto 2 Working with Oracle8 Types 3 Accessing Tables with Oracle8 Object Types 4 About the Object Iron packages=pnf_ojiabt>about 4 Installing the Object Iron packages=pnf_ojiins>howto 4 Building and using a table-specific package=pnf_ojigen>howto 4 Dropping a table-specific package=pnf_ojidrp>howto 4 Creating a Forms data block based on a table-specific package=pnf_ojidbl>howto 3 Working with Oracle8 user-defined datatypes 4 About the Type Wizard=o8_tywizab>about 4 Creating an Oracle8 user-defined datatype with the Type Wizard=o8_wizcre>howto 4 Editing an Oracle8 user-defined datatype=o8_typedi>howto 4 Deleting an Oracle8 user-defined datatype=o8_typdel>howto 2 Using the Load Path 3 About the load path=ldp_abt>about 3 Initializing the load path=ldp_init>howto 3 Adding a directory to the load path=ldp_add>howto 3 Viewing the load path=ldp_view>howto 3 Clearing the load path=ldp_clear>howto :include d2scpus.cnt 2 Integrating with Other Products 3 Accessing non-Oracle datasources=c_openint>category 1 Procedure Builder Reference 2 Designer Tools 3 Object Navigator 4 The Object Navigator=gui_objnav>category 4 Support for Oracle8 objects=o8_over>category 4 Working with the Object Navigator 5 Creating an object=nav_create>howto 5 Selecting an object=nav_select>howto 5 Reordering an object=nav_reord>howto 5 Searching for an object=nav_srch>howto 5 Deleting an object=nav_delet>howto 5 Expanding a node=nav_exp>howto 5 Collapsing a node=nav_col>howto 5 Adding a bookmark=nav_stbkm>howto 5 Going to a bookmark=nav_gtbkm>howto 3 PL/SQL Interpreter 4 The PL/SQL Interpreter=gui_intovu>category 3 Editors 4 The Program Unit editor=gui_plsed>category 4 The Stored Program Unit editor=spu_ed>category 4 Editing features=cpue_feat>referenc 4 Using the mouse in the editors=cpue_mouse>referenc 4 Using the keyboard in the editors=cpue_keyb>referenc 3 Syntax Palette 4 The Syntax Palette=gui_synpal>category 3 Database Trigger editor 4 The Database Trigger editor=dbt_dte>category :include pdincom.cnt 2 Administration 3 DET60 and DEBLD60 executables=padm_clopt>referenc 3 File naming conventions=padm_fnconv>referenc 2 National Language Support :include nls.cnt 2 Environment Variables 3 Environment variables=d2k20envir>category :include d2kwin.cnt 1 PL/SQL Reference 2 Built-in Packages=cat_bins>category 2 Support for PL/SQL V8=pnf_plsql8>referenc; :include cplsref2.cnt :include cnfpls23.cnt 1 Examples and Demos 2 Examples=pbexmgrp>category :include d2kdemo.cnt 1 Tips and Tricks 2 For PL/SQL 3 Locate syntax errors during compile=p20rtterr>referenc 3 What's the difference between LOAD and INTERPRET?=p20rttlvsi>referenc 3 When should I attach a library rather than open it?=p20rtteditlpu>referenc 3 Paste built-in subprograms=p20rttpaste>referenc 3 Find built-in subprograms quickly=p20rttsrch>referenc 3 Pass floats through ORA_FFI on Microsoft Windows 3.1=p20rttfloat>referenc 3 Pass character data to a C function using ORA_FFI=p20rttchard>referenc 3 Terminate directory names in LOAD_LIBRARY function calls=p20rttloadlib>referenc 3 Set the NLS_DATE_FORMAT environment variable (Windows only)=dbg_nlsdate>referenc 2 For Debugging 3 Centralize your debugging workspace=p20rttnavp>referenc 3 Use other STEP options=p20rttstep>referenc 3 Use debug triggers to implement conditional breakpoints=p20rttbreak>referenc 3 Save Interpreter activity to a log file=p20rttlog>referenc 3 Save debug actions=p20rttsda>referenc 3 Use the TEXT_IO built-in package=p20rtttio>referenc 2 For Performance 3 Use a startup script=p20rttscpt>referenc 3 Where should I store program units for optimum performance?=p20rttstore>referenc 3 Store packages in libraries=p20rttlib>referenc 3 Reduce the size of a library=p20rttsize>referenc 3 Break up large packages that exceed maximum program unit size=p20rttlsiz>referenc :include tshoot.cnt 3 Procedure Builder error messages=err_em>referenc 2 Common Problems 3 Running program units from an open library=ts_runlibpu>referenc 3 Recompiling program units on the server=ts_recompserver>referenc 3 Restoring program unit validation=ts_puinval>referenc 3 Compiling program units that reference "undefined procedures"=ts_function>referenc 3 Compiling program units that reference database objects=ts_compildb>referenc 3 Changing local variable values while debugging=ts_localvar>referenc 3 Clearing the Interpreter's secondary prompt=ts_int2prmpt>referenc 3 Accessing variables in remote packages=ts_remote_var>referenc 3 Handling PL/SQL exceptions=ts_trap>referenc