As far as I know, the Copy From command only works on SqlPlus. But
you can create a cursor in your stored procedure, and do the insert on
Sybase within the loop.

HTH,
Patricia.

> ----- Mensagem original -----
> De: Woody McKay [SMTP:[Email Address Removed] Enviada em: Sexta-feira, 31 de Agosto de 2001 11:20
> Para: LazyDBA.com Discussion
> Assunto: Transparent Gateway Question
>
> Hello all,
>
> I have a problem inserting data from a local 8.1.6 table into a Sybase
> table through the Transparent Gateway.
>
> I first used 'insert into sybs_table select * from local_table' which gave
> an ora-02025.
>
> I just rtfm and saw that I need to use the COPY FROM command. My question
> is will this work around work ok in a stored procedure? I no longer have
> my gateway connection to test. I'm need to modify the stored procedure
> and email it out to someone else to test.
>
> TIA,
>
> Woody
>
>
Oracle LazyDBA home page