Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    1

    Unanswered: Create a login string for sqlplus

    I launch sqlplus from a jsp page and i want to know if it is possible to set the default scripts directory in my login script.

    My login script look like this :
    sqlplusw.exe log/pass@bd @p:/temp/select.sql

    I would like to set the scripts directory to p:/temp/, so that if the script select.sql call others scripts, these scripts will be found.

    Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107

    Re: Create a login string for sqlplus

    Originally posted by Gob
    I launch sqlplus from a jsp page and i want to know if it is possible to set the default scripts directory in my login script.

    My login script look like this :
    sqlplusw.exe log/pass@bd @p:/temp/select.sql

    I would like to set the scripts directory to p:/temp/, so that if the script select.sql call others scripts, these scripts will be found.

    Thanks
    Hi,

    The default script that SQL*Plus recognises is "login.sql"

    That is when u launch SQL*Plus, this file is automatically called.

    sqlplusw log/pass@db

    This will call login.sql from the startup directory of Sql*Plus

    Hope it Helps.
    nn

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •