![]() Some InstallationManagerfeaturesmight or might not be supported by packages. I can't find the right search terms to get a lead on this. To silently install a product package, you must first create a response file. Groom the script output to show only lines sent via dbms_output relating to pass/fail status of the test steps. (I drop/create the test objects and expected results tables on each test run to make it quick and easy to run all tests at once when moving from dev to test environments.) Currently I have an action in Toad's Automation Designer to run the scripts for all tests, with 'set serveroutput on' and the output going to a file where I check whether any tests failed. My script inserts test records, runs the calculation procedure on them, creates tables of expected results, and compares expected to actual results. I'm using PL/SQL to test a calculation program that runs as a database procedure. We have had our customers run other installers successfully so this should work properly. This is only needed if running an installer from a bat/cmd script. PASS: All records on _res actual results table have matches on expected results table for test002s Also, as InstallBuilder waits for child processes, it is not recommended to use cmd /c start /WAIT approach. PASS: All records on _res expected results table have matches on actual results table for test002s InstallBuilder includes built-in actions for the most common functionality, such as creating users, starting services or changing file permissions, but it is also possible to invoke external programs. My preferred output would look like this. Alternatively, you can simply redirect the output of SQLPlus to null like this: sqlplus -s system/password 1>/dev/null 2>&1 << EOF spool output.log select from dbatables exit EOF All the output will be in 'output.log', but your script will not echo the results to the screen. InstallBuilder allows controlling the flow of the installation using actions and rules. PASS: All records on _res actual results table have matches on expected results table for test001s PASS: All records on _res expected results table have matches on actual results table for test001s (This is simplified but it shows the kinds of messages I'm getting.) PL/SQL procedure successfully completed. I do want my own dbms_output.put_line messages. I don't want create table, insert record, drop table. ![]() In PL/SQL for Oracle running in Toad, can I suppress script output except for certain lines I want to see? e.g.
0 Comments
Leave a Reply. |