Hi sir, this video is very helpful. But its showing some errors when i ran the block. "invalid directory path" I used actual folder path 'C:\Users\Prakash\Desktop', FileName as 'Empdata.csv' But still giving me the error, i tried 'USER_DIR' also. Not working. Please help sir, Thanks in advance, Prakash
hi Sridhar, I'm having trouble in writing the output to a csv file - Lets Say a column with leading zeros is written , but when i see the csv file - those are stored as number. But i want it to be written in text format(I have tried converting using TO_CHAR and even tried LPAD in UTL_FILE). The issue is only while copying. If i convert the file to text and read it, the column has leading zeroes. Help in this is much appreciated. Thanks
there is date (with time) data from table but when it's written to csv file it only shows date. how can I get date and time information in one column in csv file?
Nice job.
Very nice!
Hi sir, this video is very helpful. But its showing some errors when i ran the block.
"invalid directory path"
I used actual folder path 'C:\Users\Prakash\Desktop',
FileName as 'Empdata.csv'
But still giving me the error, i tried 'USER_DIR' also. Not working.
Please help sir,
Thanks in advance,
Prakash
hi Sridhar,
I'm having trouble in writing the output to a csv file - Lets Say a column with leading zeros is written , but when i see the csv file - those are stored as number. But i want it to be written in text format(I have tried converting using TO_CHAR and even tried LPAD in UTL_FILE). The issue is only while copying. If i convert the file to text and read it, the column has leading zeroes. Help in this is much appreciated.
Thanks
there is date (with time) data from table but when it's written to csv file it only shows date. how can I get date and time information in one column in csv file?
Hi
I am getting a error : invalid file operation in fopen function can you please help
Screen does not have clarity