RE: COPY command inside of stored procedure

From: Jay Hostetter <jhostetter_at_decommunications.com>
Date: Fri, 08 Dec 2000 07:21:38 -0500
Message-Id: <10704.123992@fatcity.com>

You won't get it to work in a stored procedure. It is a sqlplus command.

Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA

>>> "Cale, Rick T (Richard)" <RICHARD.T.CALE_at_saic.com> 12/07/00 10:31PM = >>>
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]=20
> 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=20
> Subject: RE: COPY command inside of stored procedure

>=20


> 		Refer Metalink DOC ID 1022033.6 for copy command.

> 		AK

>=20


> 				-----Original Message-----

> 				From:	Sergey Kosourikhin

> [mailto:kosour_at_braz.ru]=20

> 				Sent:	Thursday, December 07, 2000 11:06 =

AM


> 				To:	Cale, Rick T (Richard);

> ORACLE-L_at_fatcity.com; oracledba_at_quickdoc.co.uk=20

> 				Subject:	Re: COPY command inside of

> stored procedure

>=20


> 			Hi, Rick.

>=20


> 			COPY works only in sqlplus. It's one of the =

command


> of sqlplus not sql or

> 			plsql.

>=20


> 			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

>=20
>=20


> 			> 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=20
> >
> >
> > --------
> > 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=20
> > to subscribe send a blank email to
> oracledba-subscribe_at_LAZYDBA.com=20
> > Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl=20
> >
> >

>=20
>=20


> 			--------

> 			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=20

> 			to subscribe send a blank email to

> oracledba-subscribe_at_LAZYDBA.com=20

> 			Visit the list archive:

> http://www.LAZYDBA.com/odbareadmail.pl=20
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE_at_saic.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Fri Dec 08 2000 - 06:21:38 CST