Monkeygumbo
MIS
Hi,
My procedure accepts one parameter, group_id. But its optional. If its left NULL, the program has to process all records. If it has a value, the program process all records with a group_id = the value.
I'm using a cursor that accepts the parameter currently...
CURSOR c_get_gl_rec1(p_group_id) IS
SELECT *
FROM table1
WHERE group_id = p_group_id;
but passing it a NULL won't select all records. Any suggestions?
MG
My procedure accepts one parameter, group_id. But its optional. If its left NULL, the program has to process all records. If it has a value, the program process all records with a group_id = the value.
I'm using a cursor that accepts the parameter currently...
CURSOR c_get_gl_rec1(p_group_id) IS
SELECT *
FROM table1
WHERE group_id = p_group_id;
but passing it a NULL won't select all records. Any suggestions?
MG