CODEWITHSUNDEEP
sqloracle-database
user158017
user158017

Reputation: 2991

Free Software to Allow Users to Run Oracle SQL Scripts but NOT create them

We would like to allow users to run custom Oracle 11G SQL scripts that have been created for them, complete with parameter prompts, and get a CSV extract of the resulting dataset. Right now, I just use SQLPlus and SQLDeveloper to do those things, but those tools would allow the creation of custom scripts as well, and we do not want users to try to create custom queries.

In many cases we intend to fulfill this need with Crystal Reports/Crystal Server, but we use CR XI, and sometimes very WIDE extracts are difficult to create because of the page size limitations. It also has a limit for the number of concurrent users, and sometimes we may need more.

Does anyone know of a FREE tool that can allow users to execute Oracle SQL Scripts and get file exports as a result and yet will NOT allow them to create new Scripts?

NOTE: We have a Citrix environment and therefore are able to limit where the script files are located and what access users have to those files and folders.

Upvotes: 2

Views: 818

Answers (2)

JOTN
JOTN

Reputation: 6317

I use jasper reports for that: http://jasperforge.org/index.php?q=project/jasperreports

Upvotes: 0

Justin Cave
Justin Cave

Reputation: 231661

Given that a SQL script is just a text file, I'm not sure I see how this could be possible but perhaps I'm missing something about how you see something like SQL*Plus allowing the creation of custom scripts. If you give me any tool that runs SQL scripts, I can always open my favorite text editor, write a SQL script, and have your tool run it (assuming that you allow users to create new files in your Citrix environment or to map a file from their local machines).

Personally, I'd probably create a small APEX application in the database that would present a menu that let users pick an export. Behind the scenes, the APEX app would run whatever select was necessary (I'd generally create a CLOB in the database rather than a file on the file system assuming unless you're making a great deal of use of SQL*Plus formatting commands in your scripts) and would allow the user to download the file (or use some alternate file delivery mechanism such as email).

Upvotes: 2

Related Questions