Home » SQL & PL/SQL » SQL & PL/SQL » Fcopy operation cannot be performed (9i)
Fcopy operation cannot be performed [message #320892] Fri, 16 May 2008 10:54 Go to next message
jramya
Messages: 42
Registered: April 2008
Member
Hi All,
I am trying to do a simple fcopy opertaion illustrated as in the code below
create or replace procedure UTLTESTCOPY_1 as
f1 utl_file.file_type;
begin
f1 := UTL_FILE.FOPEN('OUT_DIR','test1.TXT','R');
UTL_FILE.FCOPY(
src_location => 'OUT_DIR',
src_filename => 'test1.txt',
dest_location => 'OUT_DIR',
dest_filename => 'test2.txt');
end;

I am getting a error Fcopy should be declared.
I have created directory pointing to C:\Temp and
checked it querying the dba_directories.

It will be great if u can get me a clue.

Regards
Ramya
Re: Fcopy operation cannot be performed [message #320893 is a reply to message #320892] Fri, 16 May 2008 10:58 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>I am getting a error Fcopy should be declared.
ERROR? What Error? I don't see any error.

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above
Re: Fcopy operation cannot be performed [message #320894 is a reply to message #320892] Fri, 16 May 2008 11:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Go to the documentation and review the parameters.

Regards
Michel
Re: Fcopy operation cannot be performed [message #321131 is a reply to message #320892] Mon, 19 May 2008 03:26 Go to previous messageGo to next message
jramya
Messages: 42
Registered: April 2008
Member
HI,
My Apologies for that.
I am getting the following error
PLS-00302: component 'FCOPY' must be declared.
I can perform fopen operation but no other function of the utl_file package.We are using Ora 8.1.6 version.
Please let me know if providing other information can be useful.
Regards
Ramya
Re: Fcopy operation cannot be performed [message #321134 is a reply to message #321131] Mon, 19 May 2008 03:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
.We are using Ora 8.1.6 version.

So why telling us 9i in title?
Check if the function existed in 8.1.6

Regards
Michel
Re: Fcopy operation cannot be performed [message #321139 is a reply to message #321134] Mon, 19 May 2008 04:00 Go to previous message
jramya
Messages: 42
Registered: April 2008
Member
Hi,
Thank you for your response.
Yes,that api was added in 9i release only.As I have worked earlier in higher versions,it dint came in mind that functionality itself may go missing Wink.
Previous Topic: MAX INSERT PER SECOND
Next Topic: How to join two SQL queries
Goto Forum:
  


Current Time: Sat Dec 03 12:24:23 CST 2016

Total time taken to generate the page: 0.10731 seconds