Oracle10g Forms II: Customize Internet Applications­Vol B Page iii Table of Contents SECTION 1 ..................................................................................................................................................................1 INTEGRATING SERVER-SIDE LOGIC ................................................................................................................1 A CCESSING D ATABASE S ERVER -S IDE L OGIC .............................................................................................................2 Object Navigator Database Objects Node ................................................................................................................... 3 I NTEGRATING D ATABASE C ONSTRAINTS ...................................................................................................................4 I NTEGRATING D ATABASE P ROCEDURES ....................................................................................................................6 Guidelines For Integrating Database Procedures......................................................................................................... 6 Application Partitioning ......................................................................................................................................7 On The Application Server Or The Database Server? ­ An Example ......................................................................... 7 SALARY_VALID() Example ..................................................................................................................................... 8 On The Application Server Or The Database Server? ­ Key Points ........................................................................... 9 Moving Program Units From Application To Database Server................................................................................. 10 Accessing The Database Stored Program Unit .......................................................................................................... 13 Rules And Restrictions .......................................................................................................................................15 Resolution Of Program Unit References ................................................................................................................... 15 Creating A Database Server Procedure ............................................................................................................16 I NTEGRATING D ATABASE T RIGGERS .......................................................................................................................17 Create Database Server Trigger........................................................................................................................18