Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009

    Red face Unanswered: re-runable scripts

    I am working on a project for school where the script is to be re-runanable. I have googled it and what was provided didn't make much sense. How are scripts made re-runnable?

    This is how he describes what he wants:

    A re-runable sql script file for this step, called p2_step2.sql, which must be called from parent sql script file project.

    I haven't heard of calling a script within a script like this. Of course, I'm realtively new to sql too.

    I am running windows xp professional and sqlplus, if that helps

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    I am not clear on the terminology either.
    Any script can be invoked more than once; but it may come down to errors.
    For example, if a SQL file contains CREATE TABLE statement, an error would result the 2nd time it is run because the table already exists.

    I strongly suggest you get clarification how re-runability is measured.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2003
    West Palm Beach, FL

    Cool re-startable?

    As anacedent points out, the terminology does not make sense. All scripts can be run more than once, therefore your teacher may refer maybe to RE-STARTABLE.

    A re-startable script can (or has to) be executed after it fails and be able to complete it's task.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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