Post reply

UDF Globals

  • July 23, 2005 at 9:29 pm

    #363247

    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

    #576693

    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