Oracle Shooter

PRAGMA SERIALLY_REUSABLE --============================================ PRAGMA :- a.     It signifies that the statement is a pragma (compiler directive). b.     Pragmas are processed at compile time, not at run time. c.     They do not affect the meaning of a program, they simply convey information to the compiler. PRAGMA SERIALLY_REUSABLE in ORACLE:- a.     The pragma  SERIALLY_REUSABLE indicates that the package state is needed only for the duration of one call to the server b.     After “ PRAGMA SERIALLY_REUSABLE” call, the storage for the package variables can be reused, reducing the memory overhead for long-running sessions. c.     If a package has a spec and body, you must mark both. You cannot mark only the body. d.     Serially reusable packages cannot be accessed from database triggers or other PL/SQL subprograms that are called from SQL statements. If you try, Oracle generates an error. WHY PRAGMA SERIALLY_REUSABLE ? Because the state of a n

Interface and API in Oracle --============================================== Interface:-  --======================================= User Interface, we have to write codes for validation and insertion of data’s in Interface tables and then in Oracle base tables ·           The good is that if there is failure of record, they remain          in the table until either fixed or purged. Supplier Base Tables:-  AP_SUPPLIERS AP_SUPPLIER_SITES_ALL AP_SUPPLIER_CONTACTS  Supplier Interface Tables: AP_SUPPLIERS_INT  AP_SUPPLIER_SITES_INT AP_SUP_SITE_CONTACT_INT Supplier Error Interface Table:- AP_SUPPLIER_INT_REJECTIONS  Supplier Interface import Programs:- 1.    Supplier Open Interface Import 2.    Supplier Sites Open Interface Import 3.    Supplier Site Contacts Open Interface Import API:- Application Programming I