Professional Web Applications Themes

Help with ACCEPT Syntax - Oracle Server

Hello, I'm not sure if this is possible, but i'm creating a script that prompts a user to enter some data. This is basically a script builder which builds scripts based on what the user enters. The only problem i'm running into is the OLD and NEW lines are printing out in the spool file. When I run the spool file, the line right after the old new line does not get executed because of the ; missing on the old and new and then being on the next line.. Hopefully i'm not confusing you. Is there a way to ...

  1. #1

    Default Help with ACCEPT Syntax

    Hello,

    I'm not sure if this is possible, but i'm creating a script that
    prompts a user to enter some data. This is basically a script builder
    which builds scripts based on what the user enters. The only problem
    i'm running into is the OLD and NEW lines are printing out in the
    spool file. When I run the spool file, the line right after the old
    new line does not get executed because of the ; missing on the old and
    new and then being on the next line..

    Hopefully i'm not confusing you.

    Is there a way to turn these off? some environment variable for
    something similar that I can eliminate these lines from printing in
    the spool file?

    Thanks for your help!

    Sean
    Sean Guest

  2. #2

    Default Re: Help with ACCEPT Syntax

    Try:
    set verify off

    For example:

    SQL> select '&val' from dual;
    Enter value for val: abc
    old 1: select '&val' from dual
    new 1: select 'abc' from dual

    'ABC'
    --------------------------------
    abc

    SQL> set verify off
    SQL> select '&val' from dual;
    Enter value for val: xyz

    'XYZ'
    --------------------------------
    xyz


    Anurag

    "Sean Clark-McCarthy" <net> wrote in message news:google.com... 


    Anurag Guest

  3. #3

    Default Re: Help with ACCEPT Syntax

    Hi Sean

    use set verify off, an example:

    SQL> set verify off
    SQL> accept some_user prompt 'user to accept : '
    user to accept : vpd
    SQL> select username,password
    2 from dba_users
    3 where username=upper('&some_user');

    USERNAME PASSWORD
    ------------------------------ ------------------------------
    VPD 93AEF50C31AC2973

    SQL>

    hth

    kind regards

    Pete
    --
    Pete Finnigan
    email:com
    Web site: http://www.petefinnigan.com - Oracle security audit specialists
    Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
    Pete Guest

Similar Threads

  1. Accept Cookies?
    By mooresm in forum Macromedia Contribute General Discussion
    Replies: 1
    Last Post: August 8th, 07:01 AM
  2. CF 7 Administrator won't accept PWD
    By Peterc0527 in forum Coldfusion Database Access
    Replies: 7
    Last Post: March 7th, 05:49 PM
  3. Can ASP accept a POST over 4GB
    By Curt_C [MVP] in forum ASP
    Replies: 8
    Last Post: July 15th, 01:19 PM
  4. Changes won't accept.
    By Ken Brott in forum Windows XP/2000/ME
    Replies: 1
    Last Post: July 7th, 03:02 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139