copy command inside a procedure [message #36189] |
Fri, 09 November 2001 00:28 |
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 |
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.
----------------------------------------------------------------------
|
|
|