Toad World® Forums

PL SQL in Toad for data analyst

Is it possible to run PL-SQL in TDA and export it to a text file?

Awhile back you could execute an Oracle function that returned a ref cursor. We then displayed as grid data. I don’t know if this still works. If so you should be able to export the data. I have not tried with an anonymous block.

Debbie

Do you have any examples of this? I am a fuzzy on how to return the ref cursor.

I’m pretty sure there is lots of examples on the internet

Debbie