July 23, 2005 at 9:29 pm
I have written a udf that needs to read 1 base value from a table before it can do the calculations. The user would probably use it in a view to bring back 3 or 4 columns of calculated data. The base value would never change.
I would like to load the table info 1 time and use it many times during the session.
Is this possible and how?
Thank you,
MikeD
July 25, 2005 at 4:03 am
Hi Mike,
ORACLE has packages on the database level, and they perform exactly that way - initialize themselves on per session basis. I'm afraid that M$$QL doesn't have that feature, at least not in version 2000. There is something similar, called context info: you can store 128 bytes of information on per session basis. But, if you have to query it, I think that it reads a system table.
Regards,
Goce.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply