How to generate a spool file in pl/sql

Not sure if I understood your problem correctly, but if you run the select and when looping through the result you decide the file name.

So something like: SQL. Copy Code. Posted Jan am Wendelius. Add your solution here. OK Paste as. Treat my content as plain text, not as HTML. Existing Members Sign in to your account. This email is in use. Do you need your password? Submit your solution! When answering a question please: Read the question carefully. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.

If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question. Let's work to help developers, not make them feel stupid. Related Questions. Spool to a file when using bind variables.

How to generate dynamic log file. How to listmonth names dynamically. Open a file that has a dynamically generated file name with date. Hi Ollie, i have one more question. But, i have a shell script which invokes this SQL script and spools the output to text file. I registered the shell script in Oracle apps, and when i submit a request from apps to run. It shows normal and running but it never gets completed. Do, i have to make any changes to the above script when invoking from a shell script.

If you are running it in the background, I'd worry about where you expect the output to go. To run this from a script in SQL Plus like myscript.

Show 1 more comment. Florin Ghita Florin Ghita Won't work in that way. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.

Linked 5. Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled.