oracle stored procedure [message #182953] |
Tue, 18 July 2006 23:21 |
alleriod
Messages: 2 Registered: July 2006 Location: Philippines
|
Junior Member |
|
|
is '0002','00000010','0001' = STR_POST_CODE in here?
1. FOR NUM_INDEX IN 1 .. IN_ARRAY_COUNT LOOP
STR_POST_CODE := STR_POST_CODE || ',' || IN_POST_CODE(NUM_INDEX) ;
END LOOP;
2.ROW_EMPLOYEE_PART.POST_CODE IN ('0002','00000010','0001')
please reply..
i'm finding wrong logic in passing array to a variable
|
|
|
|
Re: oracle stored procedure [message #183200 is a reply to message #183146] |
Wed, 19 July 2006 22:14 |
alleriod
Messages: 2 Registered: July 2006 Location: Philippines
|
Junior Member |
|
|
yes!
because I have this condition in my stored procedure to check if the post code that i passed from the form contains the postcode for the select statement that i have in the SP which is selected in ROW_EMPLOYEE_PART.
this is my condition:
1. IF ROW_EMPLOYEE_PART.POST_CODE IN ( STR_POST_CODE ) THEN
i try to check if using IN is correct that is why i test it by assigning values like this ROW_EMPLOYEE_PART.POST_CODE IN ('0002','00000010','0001')
if i use number 1 it goes to my ELSE statement instead in my IF statement).
[Updated on: Thu, 20 July 2006 01:18] Report message to a moderator
|
|
|