export oracle data block to excel

Question

according to this post I try to export my data to Excel, after several challenge now my problem is it seems work well but I can not see the exported excel file!!!!

(first solution's http://www.protalk.in/oracle/plsql-tips-package-for-exporting-data-to-excel/ )

I use '/' for my directory.

please help me. where is the exported file? what else should I do? I use oracle 6.

Please post did you solve your problem or not?

kupa
– kupa

2010-11-11 11:22:36 +00:00
Commented Nov 11, 2010 at 11:22 — kupa
– kupa, Commented Nov 11, 2010 at 11:22

kupa · Accepted Answer · 2010-11-11 10:23:35Z

1

I am not sure if I think right but...Can you run this query and tell me the result(especially what does column "value" holds?):

select * 
from v$parameter
where name='utl_file_dir'

answered Nov 11, 2010 at 10:23

kupa

1,9005 gold badges25 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Amir Over a year ago

value of 'utl_file_dir' is '/' thats all! :(

kupa Over a year ago

what does it mean "I use '/' for my directory."?? can you write path ,instead of '/', which indicates some folder that you can access??

Amir Over a year ago

if I do I receive error Ora-29280! I dont think it's a correct way.help plz :(

kupa Over a year ago

create directory dir_name as 'path_to_your_folder'; and then indicate dir_name instead of '/'..try

Amir Over a year ago

I asked DBA still under progress, but it is so funny isnt it.one more this if we chose '/' our file will go where?

|

Collectives™ on Stack Overflow

export oracle data block to excel

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related