How to write a test case in PL/SQL
Hi Experts,
How to write a test case in PL/SQL to check whether the parameter of a procedure (eg email iddress) takes only lower case ,i did this way in my procedure
If(emailadd) <> lower(emailadd)then
raise_app_error_
But this can be checked n test case
please guide me with pseudo code
thanks n advance
Software/Hardware used:
Software/Hardware used:
ASKED:
January 6, 2009 10:59 AM
UPDATED:
January 9, 2009 7:04 AM
RELATED QUESTIONS
- I am getting ORA-01422: Exact fetch returns more than requested number of rows
- calling reports in pl/sql code
- PL/SQL: How to check address NOT NULL but can take -(hyphen) instead being NULL
- PL/SQL: How to check that parameter is case-sensitive?
- PL/SQL - Attribute to test not null and can take specific value instead
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
Could you please explain what you mean with “But this can be checked n test case” ?
hi i need to check the above logic using a test case ?? how can i implement the same??