Re: Transfering Records To Another Table

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

Or could I also do it the other way and just have the variable sent to the [Quoted] procedure on the server? This way, would I use the Procedure Builder? If [Quoted] 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 - 14:59:21 CEST