Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using the COPY command

Status
Not open for further replies.
rich2020

rich2020

Technical User
Oct 20, 2000
6
US
What is the syntax for using the copy command in a procedure or package?
I get compile errors even when I don't use the set arraysize and set copycommit parameters.
 
Sort by date Sort by votes
I think "copy" is a SQL*Plus command, so you won't be able to use it inside of a procedure or package. You can only use SQL and PL/SQL commands in them.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
969
Livia8
Livia8
Andrzejek
  • Locked
  • Question
Copy a table from Test to Production
Replies
1
Views
323
carp
carp
Olutee360
  • Locked
  • Question
Group by using values in a range 1
Replies
4
Views
429
Olutee360
Olutee360
torturedmind
  • Locked
  • Question
Week of the year
Replies
0
Views
337
torturedmind
torturedmind
kernal
  • Locked
  • Question
Extract string before the first "-" it finds and the space prior to the "-"
Replies
5
Views
540
carp
carp

Part and Inventory Search

Sponsor

Back
Top