PL/SQL Branching Logic

From: <dds_at_visi.com>
Date: Wed, 12 Jan 2000 18:27:31 GMT
Message-ID: <85ih20$cn3$1@nnrp1.deja.com>

Hi all,

I am working on a project where I have the requirement of branching to a specific procedure based upon a string variable. The variables look like this 'ABCDEFGH', ABCDEFIJ', etc.

I have the option to change the strings to make them easier to evaluate. There is the possibility of up to 10000 of these strings to exist.

PL/SQL is pretty limited with its IF-ELSE-END branching structure. I do not want to have a IF-ELSIF-END structure with 10000 evaluations.

Anyone have a similar problem or a solution?

Thanks,

Dan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 12 2000 - 12:27:31 CST