Home » SQL & PL/SQL » SQL & PL/SQL » copy command inside a procedure
copy command inside a procedure [message #36189] Fri, 09 November 2001 00:28 Go to next message
prakash
Messages: 24
Registered: October 2001
Junior Member
hai friends ,this is the procedure
create or replace procedure proc_name(id in number) as
begin
copy from scott/tiger@world to ora/ora@us create table_name using select * from table_name;
end;

this gives an errorr saying
encountered the symbol "from" when expecting one of the following........
encountered the symbol "to" when expecting one of the following........

can any one help me out....
thanks

----------------------------------------------------------------------
Re: copy command inside a procedure [message #36197 is a reply to message #36189] Fri, 09 November 2001 06:20 Go to previous message
hello
Messages: 17
Registered: November 2001
Junior Member
Prakash,
Since it is a SQL*PLUS command u cannot use it in a Procedure.

If u have just the line in the .sql and run it, it will work fine.

----------------------------------------------------------------------
Previous Topic: Re: Thanks,Orashark.But ??
Next Topic: Try to execute operating system command - RPC Error
Goto Forum:
  


Current Time: Sat May 18 21:15:27 CDT 2024