05-30-2008 05:42 AM - edited 03-14-2019 02:18 AM
Hi Everybody,
I'm using with success an DBGET and a DBREAD to read my oracle database.
Now I'm trying to use the DBWRITE step (using the same DSN) but is not working.
When I execute the query below, i receive OK from my script my the Oracle database is not updated
UPDATE totem.dbpoupexonline
SET cadastrodataalt = SYSDATE,
cadastrouseralt = $CPF,
bloqueio_senha_ura = '1',
cadastroaplicalt = 'URA',
cadastroaplicobs = $NumeroDiscador WHERE cadastrocpf = $CPF
All the variables are string.
Is there any way to know exactly what the IPCC is sending to Oracle and what the Oracle is returning
to IPCC ??
Any tip will be welcome
My Best Regards,
Thanks in Advanced
06-05-2008 02:23 PM
Here is a working statement for updating a table (using DB Write step)
UPDATE Afterhours SET Afterhours = 1 WHERE BranchNumber = $strBranchNumber
This link is to enable the Database Subsystem.
Once it's enabled and you are connected to the database you can use the DB steps to get, write , read and release the database.
06-12-2008 02:40 PM
Hi Ebreniz,
Thanks for your reply...
Now Im using the correct SQL Syntax, but I found another issue..
I can make just one SQL UPDATE in my Oracle 9i Database. After that, I cannot connect to my database, even using an SQL SELECT. I have to wait sometime to be able to connect...
Thanks a Lot
My Best Regards,
Andre Lomonaco
06-12-2008 10:31 PM
You have to release the DB before using it again. It uses from the ammount of connections you specify at CRS>Subsystems>Database
"Max Connections" for some time than a timeout (from CRS or Oracle) kicks in and connection is released.
Better use DB Release node in your script.
Personaly i have a script which updates and inserts values in a Oracle table max 15 times a min.
06-17-2008 05:20 AM
Hi Chavdar_Baramov,
Thanks a lot for your reply...
I agree 100% with you....
I'm using Max Connections = 7 and every time I use DBREAD or DBWRITE I include after a DB Release in all options
What version of IPCC and Oracle are you using ?
Did you made any special configuration in your Oracle Database ?
if is possible, can you share your script to me ? I wanna test him in my network
Or if you wanna help more, I can send you my script to you take a quickly look...
My Best Regards,
Andre Lomonaco
06-17-2008 05:30 AM
IPCC 7.2
CRS 4.0(4)
Oracle 9.2
Write me to chochko@gmail.com and i`ll send you one of my scripts with DBWRITE.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: