Re: Stored Procedures and SQLCA record access

The only problem with this approch is that on a loaded system, it is possible that the value of the global variable will be updated before the second stored procedure can retrieve it. You will have to set up some type of locking plan in place to single thread this activity. Madison Pruet