Home -> Mailing Lists -> Oracle-L -> Re: Validating in PL/SQL using associative arrays

Re: Validating in PL/SQL using associative arrays

From: Rich Jesse <rjoralist3_at_society.servebeer.com>
Date: Tue, 14 Jan 2014 12:35:59 -0600 (CST)
Message-ID: <878706f52fc9a06fdde5f1152377dc40.squirrel_at_society.servebeer.com> 





Sayan replies:



> You can do it simply with

> IF t_valid_schema.exists(p_owner) THEN




A-ha!  I *knew* it must be simple, but I didn't have the right terms to
search for an example.



Awesome!  Thanks much!


Rich



[snip]


>> --      IF t_valid_schema(p_owner)%NOTFOUND THEN
>> --              RETURN;
>> --      END IF;
>>
>> END test_assoc;
>> /





--
http://www.freelists.org/webpage/oracle-l


Received on Tue Jan 14 2014 - 19:35:59 CET












Original text of this message