Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: kevin on March 25, 2009, 10:20:31 PM

Title: database dip
Post by: kevin on March 25, 2009, 10:20:31 PM

How are database tables updated using dip in stratergy? I mean is thru procedures or is another way to update?



Thanks

Title: Re: database dip
Post by: cavagnaro on March 26, 2009, 04:25:53 AM

best way is to use SP in your DB directly, faster and safer.

Title: Re: database dip
Post by: victor on March 26, 2009, 05:50:00 AM

I strongly suggest using a stored procedure to do this, especially if you are running Oracle.
When it comes to quick and dirty updates, URS's update is more than enough; however, when it involves multiple records in several tables, stored procedure would be able to do it much faster, more reliably, and more importantly, you will have a much better ability for error-handling.

If you are just updating value A in Table B, then URS update functionality should suffice.

Vic