0

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.

Community
  • 1
  • 1
Amir
  • 1,919
  • 8
  • 53
  • 105

1 Answers1

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'
kupa
  • 1,861
  • 5
  • 25
  • 41
  • value of 'utl_file_dir' is '/' thats all! :( – Amir Nov 11 '10 at 10:26
  • what does it mean "I use '/' for my directory."?? can you write path ,instead of '/', which indicates some folder that you can access?? – kupa Nov 11 '10 at 10:31
  • if I do I receive error Ora-29280! I dont think it's a correct way.help plz :( – Amir Nov 11 '10 at 10:36
  • create directory dir_name as 'path_to_your_folder'; and then indicate dir_name instead of '/'..try – kupa Nov 11 '10 at 10:39
  • I asked DBA still under progress, but it is so funny isnt it.one more this if we chose '/' our file will go where? – Amir Nov 11 '10 at 10:41
  • In windows I don't know where will it go:D but in linux maybe it will go in a root directory(not sure):) – kupa Nov 11 '10 at 10:43
  • I can not use this way, help me in another way plzzzzzzzzzzzzzzz – Amir Nov 16 '10 at 06:49
  • I still have problem plz help me:(( – Amir Nov 17 '10 at 11:56