Get Table Structure of Stored Procedure Output Table

  • I guess you're out of luck then.

    There's no automated way to do it, so your only option is talk to the DB developers and make them notify everyone interested that the stored procedure has changed.

    A DDL trigger could do that automatically, but I wouldn't go this far. Maybe it could be a solution if you can't settle for a human-managed process.

    -- Gianluca Sartori

  • Two cow-boys, Jim and John, were slowly riding toward Tucson, in the 1870's ...

    One of them, Jim, having some physiological needs, jumped down his horse, and went to hide himself behind a huge rock (in the desert).

    Unfortunately, hidden in the rock, there was a bell snake that "kissed" him just "there" ...

    Jim started screaming: "John, save me ! run to the city and ask to the doctor what we need to do !"

    Cloppete, cloppete, ... John went to the doctor and said: "Help ! help! my friend has been hit by a bell snake, what I have to do ?"

    The doctor (stinking of gin) replied: "It's easy: you have to cut where the snake hit and suck out the venom".

    John went back.

    Jim said: "Help me ! tell me what the doctor said".

    "That you have to die", John replied.

    😛

Viewing 2 posts - 16 through 16 (of 16 total)

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