SQL Server Performance

New Hire Alert - Oracle EBS

Discussion in 'General Developer Questions' started by Noora, Dec 25, 2010.

  1. Noora New Member

    Good morning,
    I have created an alert which fires when new employee is been hired. This alert should be sent to the HR officer with the new employee's details. Unfortunately, when I test it , it does n't work. So, could someone check the SQL statemnets and tell me what's wrong?
    this is the query in general:
    SELECT EMPLOYEE_NUMBER,
    FULL_NAME,
    EMAIL_ADDRESS,
    ORIGINAL_DATE_OF_HIRE
    INTO &EMPLOYEE_NUMBER,
    &FULL_NAME,
    &EMAIL_ADDRESS,
    &JOINING_DATE
    FROM PER_ALL_PEOPLE_F
    WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND
    EFFECTIVE_END_DATE
    AND TRUNC(SYSDATE) = TRUNC(ORIGINAL_DATE_OF_HIRE)
    and this is when i try to test it :
    SELECT EMPLOYEE_NUMBER,
    FULL_NAME,
    EMAIL_ADDRESS,
    ORIGINAL_DATE_OF_HIRE
    INTO &EMPLOYEE_NUMBER,
    &FULL_NAME,
    &EMAIL_ADDRESS,
    &JOINING_DATE
    FROM PER_ALL_PEOPLE_F
    WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND
    EFFECTIVE_END_DATE
    AND TRUNC(SYSDATE) = to_DATE('26-DEC-2010','DD-MON-YYYY')
  2. FrankKalis Moderator

    Welcome to the forum!
    This is a mainly SQL Sevrer focussed community. Since you are asking an Oracle related question, you might be better off doing so in a community dedicated to Oracle.
  3. satya Moderator

    As Frank reminded correctly that your query relates to Oracle it is not possible here to answer, you may be confusing about SQL statements and this is related to PLSQL.
  4. Noora New Member

    Thank you for replying. I have solve it.
  5. satya Moderator

    Ok what kind of error you are getting, if you think this is SQL related?

Share This Page