Re: Dumb Developer tricks
- From: Adam Musch <ahmusch@xxxxxxxxx>
- To: Richard.Goulet@xxxxxxxxxxx
- Date: Mon, 18 Jan 2010 13:58:13 -0600
create or replace function add_days
(pDate in date, pAdd_days in number)
return date
IS
rdate varchar2(20);
f_mat varchar2(20) := 'yyyymmdd hh24miss';
ret_var date;
BEGIN
select to_date(to_char(pDate+pAdd_days, f_mat), f_mat)
into ret_var
from dual;
return ret_var;
END;
/
On Mon, Jan 18, 2010 at 12:51 PM, Goulet, Richard
<Richard.Goulet@xxxxxxxxxxx> wrote:
> All,
>
> I'm going to start a new thread away from the Undo tablespace link
> because, well this is just dumb & I'm wondering how many others have heard
> similar things. BTW I've changed names to protect the guilty.
>
> Hello all,
>
> we had a meeting with Xxxx today about commit and rollback operation.
> Xxxx advices us to not use the default Oracle commit/rollback, but to use
> instead these two procedures :
>
> - FWD_LID.TRANSACTION_COMMIT
> - FWD_LIB.TRANSACION_ROLLBACK
>
> Goals of this procedure is to store in TRANSACTION_LOG table records about
> transaction performed.
> These records will be used when synchronisation will be performed between
> XXX online and XXX offline. It enables mechanism used to manage the
> synchronisation to prevent lost of data on long running synchronisation.
>
> So, now, each time a script that modified data must be executed, we must
> too use these two procedures to commit or rollback.
>
> Feel free to forward to other people that deals with transaction somewhere
> in development/database administration/...
>
> Dick Goulet
> Senior Oracle DBA/NA Team Lead
> PAREXEL International
> 900 Chelmsford St, Suite 310
> Lowell, MA 01821
> 978.614.2857
> Richard.Goulet@xxxxxxxxxxx
>
> The information transmitted in this communication is intended only for the
> person or entity to which it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this information by
> persons or entities other than the intended recipient is prohibited. If you
> received this in error, please destroy any copies, contact the sender and
> delete the material from any computer.
>
--
Adam Musch
ahmusch@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
