Programmer-Designer »   Register   Login   Logout   FAQ 
 Buyer-Project Manager »   Signup   Login   Post a Project   Logout   FAQ 
Browse Recent projects :: Post your Project :: Testimonials onmouseover="status='Click in Explorer -OR- press Ctrl and D in Netscape.';return true" onmouseout="status=' ' ">bookmark :: tellafriend :: affiliate programaffiliate program :: contactus :: homepage

Project: Simple Oracle Stored Procedure
ID: 1247099118
(Cancelled Project)

Status: Closed (No bidding)
Budget: N/A
Created: 7/8/2009 at 20:25 (MST)
Bidding Ends: 7/13/2009 at 20:25 (MST)(expired)
Project Creator: newtoplsql
Rating: (No Feedback Yet) --- login to your account to pick a bid, when you are ready.
«Login» to edit the description


To insert record into Auditing table using Stored Procedure.

There are 5 batch processes that will call this stored procedure. The batch process will call the stored procedure with 'I' parameter in the beginning of the batch process. The batch will call the stored procedure with 'O' parameter at the end of the batch process. The stored procedure should insert a record into the auditing table at the begining and end of the batch process based on the 'I' and 'O' parameters.


Oracle PL SQL. Need to create Dynamic sql, execute it and insert into the auditing table by evaluating records in the 'ACFG' table.


When the SP is called with 'I' or 'O' parameter, SP should read the corresponding record in the acfg table based on the input values to the SP, build a dynamic sql,execute the sql and insert message into the auditing table. So, when the batch calls SP in the beginning of the batch process with 'I' parameter, SP should insert a record(pre batch) and when the batch calls SP with 'O' parameter at the end of the batch process, SP should insert a record (post batch).

Records in ACFG table are entered by the Application team.

I've uploaded the specification in a text format.
Attached File: audit control.txt
Project Type: Databases
OS-Platform: None
Programming Language: None
Database Type: None
View Message Board for this Project click on the view message board button to post a message for this project View Message Board for this Project
Messages Posted: 0 - You may use the message board to discuss or clarify any further details/requirements regarding this project. Price negotiations and/or direct contact with each others are not allowed including via email, AIM, chat, etc., and until a bidder has been chosen.

Programmer Bids for this project

Programmers/Freelancers Bid Delivery Within Time of Bid
(No bids have been placed yet.)

Site Terms : Your use of this website constitutes your agreement to the terms and conditions of Programmer Bids. Any bids/quotes provided by individual freelancers, programmers, web designers and consultants on this website are not recommendations by Programmer Bids - we neither provide any quotes directly to the buyer, nor do we recommend any "specific" service provider registered on our web site. Buyers and corresponding freelancers, programmers, web developers and consultants must assume responsibility for the delivery of work and payment transactions. Programmer only provides a buy/sell marketplace for interested buyers, freelance programmers and web designers to buy or sell programming and web development services, on our website. Please read and accept Terms & Conditions before using our service.

 Copyright © 2001-Current, Programmer Bids.comSM ¤ Terms of Use ¤ Privacy Policy ¤ Contact Us ¤ Tell Friends ¤ Affiliate Program Home