Updating multiple records in a single table

[Kocky]

Hello,

I have the following question:

I want to update multiple records in a single table in my Oracle database. The data that will be updated is different for each record. I am connecting through ODBC driver.

Is it possible to call a stored procedure and pass an array of parameters to it so the records are updated on the server. I don't want to send a single update statement for each record because then my network traffic will be too large. I have over 200 clients (Handheld Terminals) communicating with the Oracle database.

Thank you.

Greetings,

Pascal.

 

[bastienk]

Why does the traffic matter? Its all got to get a central collection point first and its unlikely that all units will update at the same time, isn't it? Won't you run the risk of users updating their info and then not seeing do to a forced wait at a central collection point?

You may need to configure the db to run in shared server mode instead of dedicated connections...


Bastien

Cat, the other other white meat

 

[Kocky]

The traffic does realy matter. There will be a update statement for each record in my order. So if the user picked 50 items there will ben 50 update statements flying over the network per terminal. When 30 clients would do this at the same time then I would get 50x30=1500 update statements ! I'm using a development tool called MCL to program the terminals and it only offers me this option.

But I already found a way to do it. I'm using the Oracle function COMMA_TO_TABLE to put a comma seperated string into a table and after that I browse through the table to update the different records.