Re: Transfering Records To Another Table

Yeah, my data goes from server to client to server. Table definitions... There are about five fields being copied from table to table. All either char, varchar2, date, or number and are less than 15 characters long. For each query, there are a few hundred records that are transferred. Is this what you wanted to know? I've only been working with Oracle for 2 weeks. Actually, one of the values that gets plugged into table2 is a variable that the user specifies. So would I have to do it this way? If so, I'd use the insert to another table command?

Or could I also do it the other way and just have the variable sent to the procedure on the server? This way, would I use the Procedure Builder? If so, could you give me a basic outline of performing this task?

michael_bialik_at_my-deja.com wrote in message <7n2muf$7ru$1_at_nnrp1.deja.com>...
>Hi.
> Do you copy your data from server to client and then sending it
> back to server ( insert to another table ).
> If that's the case - it is NOT the best way to do things.
> You have to create a stored procedure on server and call it
> from Developer by passing parameters.
> Is it possible for you to post a table definitions and the
> description of parameters ( what you have to copy )?
>
> Michael.
Received on Wed Jul 21 1999 - 07:59:21 CDT