What do you mean by "my C: drive (ultimately in a UNIX directory)"?
Are you trying to write data to a file on the client? Or on the server? UTL_FILE can only write to directories on the server's file system.
I'm not sure how the C:\ drive, a Windows file system identifier, can be a Unix directory. You're also talking about both Solaris and Windows 2008 (I'm guessing, I don't think there is a Windows 2007. There is a Windows 7).
Hi Justin: I forgot to mention I am developing the stored procedure through SQL Developer. I am trying to create a shell program for creating the CSV file and then integrate the cursor definition later. I want something to write to my local windows drive if possible so I can validate the logic. Eventually it wikll run as a concurrent process in Oracle Finacials and create the output file on the Unix server. For now I want to create the file locally.
UTL_FILE can only create files on the database server.
In SQL Developer, you can run a query, fetch the results, and then tell SQL Developer to write them to a CSV file on your local drive. It's not obvious to me why you would want to do that, though, since obviously your code may be quite different from the code SQL Developer uses to write the file. And it would seem easier to review the results of your query in SQL Developer rather than writing it to a separate file just to use some other tool to open the file. Perhaps you want SQL Developer to write an XLS[X] file of results that you can then use Excel to view?