This discussion is archived
13 Replies Latest reply: Apr 1, 2008 7:44 AM by 513417 RSS

Oracle 10g - iSQL*Plus URL issue

558416 Newbie
Currently Being Moderated
Hello:

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:
<HTML>
<HEAD>
<TITLE></TITLE>
</HEAD>
<BODY>
<!--Run Employee Report-->
</body>
</html>

If anyone can help me out that would great. Thank you in advance.

Message was edited by:
fullfocus

Message was edited by:
fullfocus

Message was edited by:
fullfocus

Message was edited by:
fullfocus
  • 1. Re: Oracle 10g - iSQL*Plus URL issue
    471322 Newbie
    Currently Being Moderated
    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.


    Tom
  • 2. Re: Oracle 10g - iSQL*Plus URL issue
    558416 Newbie
    Currently Being Moderated
    Hello:

    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.
  • 3. Re: Oracle 10g - iSQL*Plus URL issue
    471322 Newbie
    Currently Being Moderated
    Ok, I see what you're trying to do now. I'll get back to you.


    Tom
  • 4. Re: Oracle 10g - iSQL*Plus URL issue
    471322 Newbie
    Currently Being Moderated
    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:

    <HTML>
    <HEAD>
    <TITLE>iSQL*Plus Dynamic Report</TITLE>
    </HEAD>
    <BODY>
    <!--H1><em>i</em>SQL*Plus Report</H1>
    Run Employee Report
    </BODY>
    </HTML>

    ora9i is the name of my machine -- a Windows XP Pro SP2 installation.

    The script.sql file is:

    set pagesize 200
    select *
    from emp_details_view
    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.


    Tom
  • 5. Re: Oracle 10g - iSQL*Plus URL issue
    46630 Newbie
    Currently Being Moderated
    Hi
    I have the same problem.

    Where should we located the script if we're using oracle10G?

    Thank you in advance.

    Best regards
    chadin
  • 6. Re: Oracle 10g - iSQL*Plus URL issue
    471322 Newbie
    Currently Being Moderated
    Read my previous post. It tells you everything you need to know.


    Tom
  • 7. Re: Oracle 10g - iSQL*Plus URL issue
    558416 Newbie
    Currently Being Moderated
    Hi,

    Your instructions worked. I didn't realize I had to place the file in the htdocs directory.

    Thanks for the help.
  • 8. Re: Oracle 10g - iSQL*Plus URL issue
    46630 Newbie
    Currently Being Moderated
    Hi tom
    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.
  • 9. Re: Oracle 10g - iSQL*Plus URL issue
    471322 Newbie
    Currently Being Moderated
    Sorry. I guess I skipped right over the part of your post that mentioned 10g. I'll get back to you.


    Tom
  • 10. Re: Oracle 10g - iSQL*Plus URL issue
    46630 Newbie
    Currently Being Moderated
    HI
    Just to inform whose interesting.

    I have solve this issue on oracle10G.

    you have to edit file
    $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/isqlplus/isqlplus/WEB-INF/web.xml

    In the web.xml file,
    search for the iSQLPlusAllowScriptsURL.

    <init-param>
    <param-name>iSQLPlusAllowScriptsURL</param-name>
    <param-value>no</param-value>

    replace no with yes
  • 11. Re: Oracle 10g - iSQL*Plus URL issue
    471322 Newbie
    Currently Being Moderated
    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.


    Tom
  • 12. Re: Oracle 10g - iSQL*Plus URL issue
    46630 Newbie
    Currently Being Moderated
    Hi Tom
    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.

    Chadin
  • 13. Re: Oracle 10g - iSQL*Plus URL issue
    513417 Newbie
    Currently Being Moderated
    Hi,
    I am not able to find the entry

    <init-param>
    <param-name>iSQLPlusAllowScriptsURL</param-name>
    <param-value>no</param-value>

    in $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/isqlplus/isqlplus/WEB-INF/web.xml

    file.

    Am I missing something?

    Thanks,

    Avinash.