Answer Posted / mark

Oracle version control and change control?

Oracle Tips by Burleson Consulting

Question: Are there tools for managing a PL/SQL change
control and version control system? I want to track
versions and also track who changed a PL/SQL stored
procedure and when the PL/SQL was changed.

Answer: There are a variety of third-party Oracle change
control and version control tools

*

Open source tools such as SCCS (Source Code Control
System) for Oracle. This is superseded by the Gnu CSSC
version control software.

*

OEM change control pack from Oracle

*

Oracle's SQL Developer also has an interface for
third-party change control and version control.

*

Merant PVCS (Serena) version control for Oracle

*

Mercury ITG ( Formally Kintana) for Oracle revision,
change control and Oracle version control.

Many folks use open-source tools such as the Source Code
Control System (SCCS), which has a check-in, check-out
routine. Oracle's SQL Developer also has an interface for
change control and version control:

"With 1.1, users can now access these files from their
version control systems," Harper said. "They open them up in
SQL Developer, and then they can edit those files and return
them to their version control system."

Oracle also has SCM (Software control Manager) that has
version control for repository objects with check-in, check
out. The version control is enabled within SCM in the
Repository Administration Utility, where you choose "Options
> Enable Version Support".

Also, Kishore Pagadala has published this code snippet for
tracking PL/SQL code changes:

-- Create history table
CREATE TABLE SOURCE_HIST
AS SELECT SYSDATE CHANGE_DATE, USER_SOURCE.*
FROM USER_SOURCE WHERE 1=2;

-- Store code in hist table
CREATE OR REPLACE TRIGGER change_hist
AFTER CREATE ON SCOTT.SCHEMA
-- Change SCOTT to your schema name

DECLARE
BEGIN
IF DICTIONARY_OBJ_TYPE
IN ('PROCEDURE', 'FUNCTION',
'PACKAGE', 'PACKAGE BODY', 'TYPE') THEN

-- Store old code in SOURCE_HIST table
INSERT INTO SOURCE_HIST
SELECT sysdate, user_source.*
FROM USER_SOURCE
WHERE TYPE = DICTIONARY_OBJ_TYPE
AND NAME = DICTIONARY_OBJ_NAME;
END IF;
EXCEPTION
WHEN OTHERS THEN
raise_application_error(-20000, SQLERRM);
END;

1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

14963

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2219

---

What are do's and dont's of Interface?

2428

---

How to retry multiple errored workflow processes? What is the access level in workflow used for? How do you define start and end functions in workflow? How does they differ from normal functions? Give me some workflow tables? What is the difference between a function and notification in workflow? I have sent two different notifications to two different users and I want to wait till both they are approved to send 3rd notification. How can you achieve it? What is item type and item key in workflow? How do you use attribute values in workflow messages? How do you use lookups in workflow? What are roles in workflow and how they are used? How do you download or upload a workflow from a server? What are steps to customize the workflow? What functions can you perform from workflow administrator responsibility? To send an email to the user workflow notification is the only way or is there any other ways to send it? Give me some workflow standard procedures? How can you run/start/kickoff workflow? What is wf_engine package used for? How many processes can each workflow contain? What is Runnable option in workflow? At what level it exists? What are different types of attributes in workflow? How do you reassign a notification? What is process in workflow? How can you send direct oracle form link through workflow notifications? How can you send a notification to multiple users? Can you change the list dynamically? Can you send html code in workflow notification? I have sent two different notifications to two different users and I want to wait till atleast one is approved to send 3rd notification. How can you achieve it?

4784

---

How to create a purchase order without a requisition?

1197

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2129

---

what are the different transaction clauses in AR?

2121

---

what is the differences between internal requisition and internal sales order?

2660

---

where to define interorganization transaction charges and what are the different options?

2421

---

How can a process be deployed in soa?

1267

---

What is the concept of soa governance?

1254

---

How is choreography different from orchestration?

1135

---

What is count(*) from po_vendors(any table)?

1088

---

What are the different components of soa suite?

1209

---

How to move the one file from one instance to another instance? And your scripts also?

1123

---