barcode generator in c# windows application codeproject CH APT ER 7 SO JUS T WH A T S H APPENI NG H ERE in Font

Maker PDF 417 in Font CH APT ER 7 SO JUS T WH A T S H APPENI NG H ERE

4 rows selected. SQL> / old new 4: where 4: where unique_session_id = upper('&unique_session_id') unique_session_id = upper('01800B510001')

ID ---------225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246

TEXT ---------------------------------------------------before the loop loop 1 before sleep loop 1 after sleep loop 2 before sleep loop 2 after sleep loop 3 before sleep loop 3 after sleep loop 4 before sleep loop 4 after sleep loop 5 before sleep loop 5 after sleep loop 6 before sleep loop 6 after sleep loop 7 before sleep loop 7 after sleep loop 8 before sleep loop 8 after sleep loop 9 before sleep loop 9 after sleep loop 10 before sleep loop 10 after sleep after the loop

22 rows selected. In the preceding output, you see the first half of the test unit where the program unit was enabled, but not the second half of the program unit where it was disabled. This means you can turn debug logging on and off programmatically as needed. That s a powerful troubleshooting tool! Now that you ve seen me do the object-relational version, it s your turn to do the relational version.

Your assignment is to create a relational debug table and table package that incorporate the same functionality as the object-relational example I just showed you. Yes, you should also include the test unit. Follow these steps to debug logging happiness:

1. Write a DDL script to create a relational table called DEBUG_T with the same columns as the attributes found in TYPE DEBUG_O. 2. Save your script as debug_t.tab. 3. Create your table DEBUG_T by executing your script: @debug_t.tab. 4. Write a DDL script to create a table package specification for DEBUG_T. You should have three methods: disable(), enable(), and set_text(). 5. Save your script as debug_ts.pks. 6. Create your package specification by executing your script: @debug_ts.pks. 7. Write a DDL script to create a table package body for DEBUG_T. Remember to use the pragma autonomous_transaction; in set_text()! 8. Save your script as debug_ts.pkb. 9. Create your package body by executing your script: @debug_ts.pkb. 10. Write a test unit for package DEBUG_TS, saving your script as debug_ts.sql. 11. Open two SQL*Plus sessions. Get the unique session ID from the first session by executing script usi.sql. Then start your test unit in the first session by executing your script: @debug_ts.sql. 12. Quickly switch to session 2, and then execute a SELECT statement against table DEBUG_T so you can see the output of your test unit as it executes. Listings 7-12 through 7-16 are my solution to this exercise. Listing 7-12 is a script to create a relational table for debug logging output. Listing 7-12. A DDL Script to Create Table DEBUG_T, debug_t.tab 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 rem debug_t.tab rem by Donald Bales on 12/15/2006 rem Create debugging message table drop table DEBUG_T; create table DEBUG_T ( id number text varchar2(256), unique_session_id varchar2(24) insert_user varchar2(30) default USER insert_date date default SYSDATE tablespace USERS pctfree 0 storage (initial 1M next 1M pctincrease 0); alter table DEBUG_T add constraint DEBUG_T_PK primary key (

not null, not null, not null, not null )

18 19 20 21 22 23 24 25 26 27 28 29

id ) using index tablespace USERS pctfree 0 storage (initial 1M next 1M pctincrease 0); drop sequence DEBUG_ID_SEQ; create sequence DEBUG_ID_SEQ start with 1 order; analyze table DEBUG_T estimate statistics; grant all on DEBUG_T to PUBLIC;

Listing 7-13 is the specification for the table package for table DEBUG_T. I ve declared three methods: disable(), enable(), and conditional set_text(). Listing 7-13. A DDL Script to Create Table Package Spec DEBUG_TS, debug_ts.pks 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 create or replace package DEBUG_TS as /* debug_ts.pks by Donald J. Bales on 12/15/2006 Table DEBUG_T's package */ -- Gets the next primary key value for the table FUNCTION get_id return DEBUG_T.id%TYPE; -- Enable debug output for the specified program unit PROCEDURE enable( aiv_program_unit in varchar2); -- Disable debug output for the specified program unit PROCEDURE disable( aiv_program_unit in varchar2); -- Log debug output if enabled for the specified program unit PROCEDURE set_text( aiv_program_unit in varchar2, aiv_text in DEBUG_T.text%TYPE);

end DEBUG_TS; / @se.sql DEBUG_TS;