This content has been marked as final. Show 13 replies
What are you trying to accomplish? You could try this:
1. In the iSQL*Plus window click on Browse and navigate to the c:\demo directory on your PC.
2. Click on the script named script.sql and then on Open in the Choose File dialog box.
3. In the iSQL*Plus window, click on Load Script.
4. You should see the SQL statements in your script.sql file in the text box of your iSQL*Plus window.
5. In the iSQL*Plus window, click on Execute,
6. The results of your script.sql should be displayed on the bottom of your iSQL*Plus window.
Sorry it took so long but I finally had a chance to get back to this. This is what I did. My test.html file is located in the d:\sql directory but it could be located anywhere. It looks like this:
<TITLE>iSQL*Plus Dynamic Report</TITLE>
Run Employee Report
ora9i is the name of my machine -- a Windows XP Pro SP2 installation.
The script.sql file is:
set pagesize 200
order by last_name, employee_id
This file is located in the $ORACLE_HOME\Apache\Apache\htdocs directory which on my machine is d:\oracle\ora92\Apache\Apache\htdocs. The file has to be there because the HTTP Server configuration file d:\oracle\ora92\Apache\Apache\conf\httpd.conf has a configuration parameter called DocumentRoot which tells the HTTP Server where to look for documents. You can change the location where it will look by using symbolic links or aliases but for the sake of simplicity, I left the parameter alone.
To get the script to run, these are the steps I took:
1. In IE7, click File --> Open and browse to the location on your hard drive where the test.html file is located and click on Open and then OK.
2. This should present you with a page that says
Run Employee Report
This comes from the formatting I used in my html file above.
3. Click on Run Employee Report
4. This will take you to the iSQL*Plus login page where you will be asked to enter a Username, Password and Connection Identifier. The username should be a user who has access to the HR schema and the connection identifier can simply be the name of your Oracle SID. If you have Oracle installed on your local machine, you can leave this field blank.
5. If everything is working, the script.sql will run and the next page will have the results of running the script which will be everything in the emp_details_view.
Just to inform whose interesting.
I have solve this issue on oracle10G.
you have to edit file
In the web.xml file,
search for the iSQLPlusAllowScriptsURL.
replace no with yes
Well done. I just got finished installing 10g on Centos 5. I wanted to go through an upgrade so I installed 10.2.0.1 and upgraded it to 10.2.0.4. Just this afternoon I had finished setting up iSQL*Plus and was preparing to get back to your question. I don't want to spend a whole lot of time on iSQL*Plus since I've heard that Oracle did away with it in 11g but I did want to have it available to help answer questions like yours. You found the information in SQL*Plus User's Guide and Reference Release 10.2 Part Number B14357-01 to be helpful then? I was using it to set up iSQL*Plus. It's a bit different than it was in 9i.