Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> COPY command inside of stored procedure

COPY command inside of stored procedure

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Thu, 7 Dec 2000 08:04:04 -0800
Message-Id: <10703.123937@fatcity.com>


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 Received on Thu Dec 07 2000 - 10:04:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US