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.
I apologize for the late reply. I am trying to create a dynamic report using iSQL*Plus.
I have a HTML file which has a URL link to isqlplus and the script file.
Ok, I see what you're trying to do now. I'll get back to you.
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.
I have the same problem.
Where should we located the script if we're using oracle10G?
Thank you in advance.
Read my previous post. It tells you everything you need to know.
Your instructions worked. I didn't realize I had to place the file in the htdocs directory.
Thanks for the help.
You previous post is something about 9i.
My wondering is oracle10G which don't have apache web server.
Please appologized if i wrong.
waiting for your reply.
Sorry. I guess I skipped right over the part of your post that mentioned 10g. I'll get back to you.
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.
Yes i found it in SQL*Plus User's Guide and Reference Release 10.2 Part Number B14357-01.
Anyway, Thank you for your kindly helpful all the time.
Have a good day.
I am not able to find the entry
Am I missing something?