How to format the OracleScript output ?

[dcosta]

From the data you'll find down bellow and using the following SQL instruction
--
select lpad(to_char(Line#),4,' ') as "Line#",
rpad(Texto,80,' ') as "Parameter"
from Oracle_Script
order by Line#;
--
--
retrieves the data in this format and truncated as if the line were only 46
characters long:
--
MOMENT ISDBA USER
------------------- ------ ------------------------------
2000.09.06 10:09:22 FALSE SYSTEM

Line# Parameter
----- ----------------------------------------
...1 ...Parameter Name Va
...2 ...always_anti_join NE
...3 ...bitmap_merge_area_size 10
...4 ...cache_size_threshold m
...5 ...checkpoint_process m
...6 ...close_cached_open_cursors m
...7 ...cursor_space_for_time FA
...8 ...db_block_buffers 10
...9 ...db_block_checkpoint_batch m
..10 ...db_block_checksum FA
..11 ...db_block_lru_extended_statistics m
..12 ...db_block_lru_latches 1
..13 ...db_block_lru_statistics m
..14 ...db_file_multiblock_read_count 8
..15 ...dml_locks 30
..16 ...hash_area_size 13
..17 ...hash_join_enabled TR
..18 ...hash_multiblock_io_count 8
..19 ...log_archive_start FA
..20 ...log_block_checksum m
..21 ...log_buffer 32
..22 ...log_checkpoint_interval 10
..23 ...log_checkpoint_timeout 18
..24 ...log_checkpoints_to_alert FA
..25 ...log_simultaneous_copies m
..26 ...max_rollback_segments 30
..27 ...optimizer_mode CH
..28 ...partition_view_enabled TR
..29 ...pre_page_sga TR
..30 ...shared_pool_reserved_min_alloc m
..31 ...shared_pool_reserved_size 75
..32 ...shared_pool_size 15
..33 ...sort_area_retained_size 65
..34 ...sort_area_size 65
..35 ...sort_direct_writes m
..36 ...sql_trace FA
..37 ...timed_statistics TR
..38 ...v733_plans_enabled m

Follows the correct data in table.

SYSTEM: > select lpad(to_char(Line#),4,'.') as "Line#", rpad(Text,80,'.') as "Parameter"
2 from Oracle_Script
3 order by Line#;

Line Parameter
---- --------------------------------------------------------------------------------
...1 ...Parameter Name Value Comment..........
...2 ...always_anti_join NESTED_LOOPS ok..............
...3 ...bitmap_merge_area_size 1048576 must be greater
...4 ...cache_size_threshold must be 1000.............................
...5 ...checkpoint_process must be TRUE.............................
...6 ...close_cached_open_cursors must be FALSE............................
...7 ...cursor_space_for_time FALSE must be TRUE....
...8 ...db_block_buffers 10000 ok..............
...9 ...db_block_checkpoint_batch must be greater than 8...................
..10 ...db_block_checksum FALSE ok..............
..11 ...db_block_lru_extended_statistics must be 0................................
..12 ...db_block_lru_latches 1 ok..............
..13 ...db_block_lru_statistics must be FALSE............................
..14 ...db_file_multiblock_read_count 8 must be 32......
..15 ...dml_locks 300 ok..............
..16 ...hash_area_size 131072 ok..............
..17 ...hash_join_enabled TRUE ok..............
..18 ...hash_multiblock_io_count 8 ok..............
..19 ...log_archive_start FALSE ok..............
..20 ...log_block_checksum must be FALSE............................
..21 ...log_buffer 32768 has to be increa
..22 ...log_checkpoint_interval 10000 must be 9999999
..23 ...log_checkpoint_timeout 1800 must be 0.......
..24 ...log_checkpoints_to_alert FALSE ok..............
..25 ...log_simultaneous_copies must be 0................................
..26 ...max_rollback_segments 30 ok..............
..27 ...optimizer_mode CHOOSE ok..............
..28 ...partition_view_enabled TRUE ok..............
..29 ...pre_page_sga TRUE ok..............
..30 ...shared_pool_reserved_min_alloc must be 5000.............................
..31 ...shared_pool_reserved_size 750000 ok..............
..32 ...shared_pool_size 15000000 must be 20480000
..33 ...sort_area_retained_size 65536 ok..............
..34 ...sort_area_size 65536 ok..............
..35 ...sort_direct_writes must be TRUE or AUTO.....................
..36 ...sql_trace FALSE ok..............
..37 ...timed_statistics TRUE must be FALSE...
..38 ...v733_plans_enabled must be TRUE.............................

38 rows selected.

Does someone has the solution for this my problem wanting help me ?

thanks
Dias Costa

 

[Marco Kalter]

The maximum length of a field in the result set output is currently 40 characters. Note that result set formatting is not considered one of the primary functions of a TOracleScript. You can use the OnData event to explicitly handle result set formatting.

------------------
Marco Kalter
Allround Automations