Re: Stored Procedure Question

> > > Does anyone know of a way to uniquely identify an instance > > of a stored procedure call within the stored procedure? As an alternative, possibly better, suggestion which doesnt involve creating a program. This does require 5.01 or higher. Create a dummy table with a row that contains a serial datatype column. Create an insert trigger to set the post insert value of the serial column into a global stored procedure variable. In your stored procedure insert a record to the dummy table. That will set the global variable to the value of the serial datatype. Use this value as the name of the file as it is guaranteed to be unique for the life of this instance of the stored procedure. Delete the row from the dummy table. Cheers - Jim My opinions are my own. They may vary with time but they remain MINE! ---------------------------------------------------------------------- Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM Company: DHL Systems Inc Phone: (415) 375-5222 Address: 700 Airport Blvd. #300 Fax: (415) 375-5019 Burlingame, CA 94010-1937 ----------------------------------------------------------------------