> Only the transaction that creates a stored procedure uses it or
> potentially
> other transactions that start after that transaction commits.
> I assumed commiting the transaction is enough to make the changes
> visible ?
> I can test disconnecting/reconnecting to see if this solves the
> problem - do
> you suggest a connection should be closed to make its metadata updates
> visible to other connections/transaction ? - this I am not so clear about.
>
> When this application starts with an empty data it creates it own 'static'
> metadata and then commits this on start up. This has never been a problem.
>
> Thanks
> Ryan
>

Clients will cache metadata on a per connection basis
Alan