Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006
    Posts
    1

    Unanswered: IF command to find the status

    Hi Gurus,

    I have a requirement where i need to capture the values in Oracle table. The Column name is Status with values either 'F' or 'S' i.e., Failure or Success. Now i need to find if the table contains value 'F'. For failure, it has to return value 0 and for a success then it has to return 2.

    lets say for example,

    i fire a query on oracle table: select status from ctrl_table;

    and if it returns the values S S F S S

    then my script should return a failure message with code 0.

    and if the query returns S S S S S

    then the script should return a success message with code 2.

    Please throw a light on this problem as i am a newbie to Shell Scripts.

    Rgds

    -S

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    You can use the "exit" SQL Plus command to set the status:
    Code:
    VAR RC NUMBER;
    BEGIN
     Select Decode(Status,'SSFSS',0,'SSSS',2,1) Into :RC
       From Status_Table Where Status_Key='MYPROC1';
    END;
    /
    EXIT :rc

    NOTE: Normally status 0 means OK and other that 0 means Failure.
    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
  •