RE: COPY command inside of stored procedure

Thanks for the reply but the document describes syntax with sql*plus which I know. I need to get
it to work in a stored procedure.

Rick

> -----Original Message-----
> From: kumaral_at_BAM.com [SMTP:kumaral_at_BAM.com]
> Sent: Thursday, December 07, 2000 11:29 AM
> To: kosour_at_braz.ru; RICHARD.T.CALE_at_saic.com; ORACLE-L_at_fatcity.com;
> oracledba_at_quickdoc.co.uk
> Subject: RE: COPY command inside of stored procedure
>
> Refer Metalink DOC ID 1022033.6 for copy command.
> AK
>
> -----Original Message-----
> From: Sergey Kosourikhin
> [mailto:kosour_at_braz.ru]
> Sent: Thursday, December 07, 2000 11:06 AM
> To: Cale, Rick T (Richard);
> ORACLE-L_at_fatcity.com; oracledba_at_quickdoc.co.uk
> Subject: Re: COPY command inside of
> stored procedure
>
> Hi, Rick.
>
> COPY works only in sqlplus. It's one of the command
> of sqlplus not sql or
> plsql.
>
> Regards,
> Sergey Kosourikhin
> ----- Original Message -----
> From: Cale, Rick T (Richard)
> <RICHARD.T.CALE_at_saic.com>
> To: <ORACLE-L_at_fatcity.com>;
> <oracledba_at_quickdoc.co.uk>
> Sent: Friday, December 08, 2000 12:04 AM
> Subject: COPY command inside of stored procedure
>
>
> > Hi DBAs,
> >
> > Does any have an example of using the COPY command
> in stored procedure. I
> > have one that works
> > ok in sql plus it works. However when I try to put
> it in a store procedure
> > both as regular sql or
> > using dbms_sql I get invalid sql statement
> although it works outside of
> > stored procedure.
> >
> > Thanks
> > Rick Cale, Science Applications International
> Corp.
> > Phone:865-481-2198, fax:865-481-8555
> > e-mail: caler_at_saic.com
> >
> >
> > --------
> > Think you know someone who can answer the above
> question? Forward it to
> them!
> > to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to
> oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> >
> >
>
>
> --------
> Think you know someone who can answer the above
> question? Forward it to them!
> to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to
> oracledba-subscribe_at_LAZYDBA.com
Received on Thu Dec 07 2000 - 10:49:17 CST