Hello everyone in my first post.

I have database and now I need do a store procedure.
What it must do?This is beginning of store procedure
CREATE PROCEDURE DANE_POINT_NUMBER (
P_NUMBER VARCHAR (25))
RETURNS (
ID_USED_CATEGORIES INTEGER,
NAME_USED_CATEGORIES VARCHAR (16))
then
I must find P_Number in one of 25 tables and owing to it I must know
ID_USED_CATEGORIES and NAME_USED_CATEGORIES. Those parametrs are
related with another table.
So,if You can help me I would be so grateful.
I'm trying use for select...do loop but I am sure that this is the
best method.