Post reply

do udf's support INSERT statements

  • November 27, 2003 at 7:51 am

    #101776

    Hi,

    I have a sproc that performs several INSERT statements.I have tried to encapsulate these insert statements into a user defined function, as the only variation in these statements is the value of the parameters that are passed.

    I get an error saying that udf's do not support INSERT statements.

    is this true? If so, will I have to repeat this insert statement multiple times in my sproc?

    cheers,

    yogi

  • November 27, 2003 at 8:47 am

    #483932

    Hi!

    What is the reason for choosing a UDF instead of SP to incapsulate the INSERT? I would go for a second SP which does the INSERT and possibly some other stuff related to the INSERT.

    Brgds

    Jonas

    BrgdsJonas

  • November 27, 2003 at 10:45 am

    #483936

    Hi Jonas.

    Right enough.Thanks bud.

    yogi

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply