On 09/30/11 12:24 AM, J.V. wrote:
> What I want to do however is within a stored procedure make a call and
> store all tables in a given schema in a list.
so procedure1 calls procedure2 (not sure why this extra level of
procedures, but I'm playing along)
and procedure2 does SELECT table_name from information_schema.tables
where table_schema='someschemaname'; and returns this data as a 'list'
(whatever you mean by that) ?
--
john r pierce N 37, W 122
santa cruz ca mid-left coast