Skip to Content

SYBASE IQ - How Do I get the obtain procedure name at runtime?

SYBASE IQ - I am trying to access the running proc name at the runtime for the purpose of logging some information. Is this possible?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 13 at 09:17 PM
    @@procidStored procedure ID of the currently executing procedure.

    You have to conevrt this procid into procedure name

    - by a look up into sysobjects with type = 'P' and with id OR

    - by a function call to object_name(id)

    HTH

    Avinash

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 18 at 06:05 AM

    Thank you.

    Add comment
    10|10000 characters needed characters exceeded