I'm trying to run a sql script file via my browser and I'm receiving the following error message:
SP2-0920: HTTP error 'URL access is disabled in iSQL*Plus ' on attempt to open URL
In my HTML file, my SQL script is located on c:\demo\script.sql. In the A HREF portion of my HTML, I am not sure whether I am referencing my script.sql correctly. I'm wondering if this could be the cause of the error message.
This is the HTML file I am running on my browser:
<!--Run Employee Report-->
If anyone can help me out that would great. Thank you in advance.
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.
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
iSQLPlus Report 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.
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.