Call: +44 (0)1904 557620 Call
version 2.0.32.1414

Release notes for version 2.0.32.1414

No	Type	Description
---	-----	----------------------------------
1	INSTALL	Advanced installer updated to 14.9
2	CODE	extract.bat clarified the inputs for the program in the header
3	CODE	Created oemrunct.bat.tem to run CT plugin projects
4	INSTALL	Added oemrunct.bat.tem to the installer
5	CODE	Created oemctbuild.pfcl.tem as a project template for the static
		code analyser build plugin
6	INSTALL	Added oemctbuild.pfcl.tem to the installer
7	CODE	Created oemctscan.pfcl.tem as a project template for the static
		code analyser scan plugin
8	INSTALL Added oemctscan.pfcl.tem to the installer
9	CODE	ctoemcsv.pfp created for oemctbuild to load the CT plugin settings
10	INSTALL	ctoemcsv.pfp added to the project
11	CODE	ctoemcsv_3e4062.pfs created for oemctbuild to load the CT
		plugin settings
12	INSTALL	ctoemcsv_3e4062.pfs added to the project
13	CODE	updatectoem.pfp created to created the OEM CT runtime scanner project
14	INSTALL	updatectoem.pfp added to the installer
15	CODE	updatectoem_65cd57.pfs created for the oemctbuild to create the 
		CT run time project
16	INSTALL	updatectoem_65cd57.pfs added to the installer
17	CODE	oemctbuild.tem created as the output repo template for the static 
		code analyser plugin
18	INSTALL	oemctbuild.tem added to the installer
19	CODE	PFCL.config.tem updated to add schema specifier for PL/SQL code 
		scanning projects
20	CODE	PLSQLInit.pfp created to initialise a PL/SQL code scan project
21	INSTALL	PLSQLInit.pfp added to the installer
22	CODE	plsql.tem project template modifified to use the PLSQLInit.pfp policy
		and not the auditor initialisation policy
23	CHECK	PLSQLInit.pfp check2 ID changed from AUI00002 to PLI00002
24	CHECK	PLSQLInit.pfp check1 ID changed from AUI00001 to PLI00002
25	CHECK	PLSQLInit.pfp check added to gather all Oracle default users for use in 
		further checks
26	CHECK	PLSQLInit.pfp check added to gather all Oracle default roles for use
		in further checks
27	CHECK	PLSQLSummary.pfp created to support the main features of the static
		source code scanner
28	CHECK	PLSQLSummary.pfp - Check added as stabalisation for the policy
29	CHECK	PLSQLSummary.pfp - check added to summarise all PL/SQL in the database;
		can be for all NON-Oracle PL/SQL or for a specific schema - controlled
		by the PFCL.config interface
30	INSTALL	PLSQLSummary.pfp added to the installer
31	CODE	plsql.tem project template updated to add the PLSQLSummary.pfp policy
		template to the project
32	CODE	PLSQLSummary.pfp - bug fixed in summary view where NIL was quoted and
		should not have been
33	CODE	plsql_summary.tem created to perform the driving table for the PL/SQL
		code scanner project
34	INSTALL	plsql_summary.tem added to the installer		
35	CODE	plsql.tem updated to remove single_db.tem and multiple_db.tem report
		templates
36	CODE	plsql.tem updated to add the plsql_summary.tem report template
37	CHECK	PLSQLSummary.pfp updated the summary check to also detect if the PL/SQL
		code is wrapped
38	CHECK	PLSQLSummary.pfp updated column list in the check
39	CODE	pfclscan_repo.css modified the table width in CSS to use the fuill screen
		if it is available
40	CODE	pfclscan_repo.css modified the font size for the data table to smaller
		for to allow the data to better fit in the default report
41	CHECK	PLSQLSummary.pfp - Check added to get all PL/SQL source code from the 
		database for the selected code to be analysed.
42	CHECK	PLSQLSummary.pfp - Dump check modified to only gather the names of the
		code not the actual code as 10027 and 1489 errors occured as the code
		is too big for PL/SQL buffer size or SQL line length
43	CODE	PLSQLDump.pfp created to dump dynamic lists from the database such as
		PL/SQL code, dependencies and permissions
44	CODE	plsql.tem - PLSQLDump.pfp policy added to the PL/SQL code scanner project
		template
45	INSTALL	PLSQLDump.pfp added to the installer
46	CHECK	PLSQLDump.pfp - stabalisation check added to the policy
47	CHECK	PLSQLDump.pfp - Check added to write each piece of PL/SQL source code
		to the results field for later extraction to files
48	CHECK	PLSQLDump.pfp - code dump check changed to use the main driving loop 
		for input rather than a separate check for listing source
49	CHECK	PLSQLSummary.pfp - removed the check that dumps the code names
50	CODE	New function added into Lua so that its possible to spool a sql file
		from a Lua check and write the results to the filesystem
51	CODE	Splash Login screen logo modified to remove PFCLScan logo
52	CODE	lua function PFCLSQLSpool modified to correctly count in two parameters
		and not three
53	CHECK	PLSQLDump.pfp - Dump PL/SQL Coce check modified to change the columns 
		to a single static result column
54	CODE	Lua function PFCLSQLSpool modified to clarify the return message back
		the Lua calling function
55	CODE	Lua function PFCLSQLSpool modified to eliminate the addtional 
		in the spool output 
56	CODE	Lua function PFCLSQLSpool modified to return a message to Lua if
		the SQL text is not present
57	CHECK	PLSQLDump.pfp modified the Dump PL/SQL check to dump all code for 
		a schema or all non Oracle users
58	CHECK	PLSQLDump.pfp modified the Dump PL/SQL check to ensure that the file
		name for each source file does not include a space
59	CHECK	PLSQLDump.pfp modified the Dump PL/SQL check to convert into a Lua 
		Loop check
60	CODE	Ticket #884059: Manage Check screen modified to allow a linked file of type L for
		a Lua Loop check
61	CODE	Ticket #884059: Manage Check Linked file dialog changed in multiple places to save
		the sep, check ID and number of vars if the check is L type
62	CODE	Ticket #884059: Manage Check Linked file - was being reset to type X for type L when
		the edit linked file dialog was closed
63	CODE	Ticket #884059: Manage Check save check changed to allow a linked file of type L
		to retain the check ID, Separator and Number of checks
64	CODE	Ticket #884059: LoadPolicy updated to deal with LUA LOOP checks
65	CODE	Ticket #884059: SavePolicy updated to deal with LUA LOOP checks
66	CODE	Ticket #884059: Edit Linked file dialog changed to allow LUA LOOP checks to
		assign X type linked files (internal) and also Loop linked files
67	CODE	Ticket #884059: Manage Check screen load did not set the type of the linked
		file; this is now set
68	INSTALL	New directory added to the installer for the code scanner to dumo PL/SQL
		source code to for further analysis
69	CHECK	PLSQLDump.pfp modified to include the full path to the source code storage
		for PL/SQL
70	CODE	oscan.exe SQLSpool modified to use the spool output directory for SQL Spooled
		files generated from Lua
71	CODE	Ticket #941749: ManageCheck Load was displacing the linked file type to 
		put the type in the number of variables field and this corrupted a lua
		loop linked file entry
72	CHECK	PLSQLDump.pfp - Dump PL/SQL Code check modified to dump the code to the new 
		spool directory
73	INSTALL	source_code directory renamed to spool to make it more generic in use