Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: usage of package variables

    Hi,
    I want to use certain variables which have been declared in the package ie global variables .
    These variables are to be accessed in a trigger.
    how do i do this.
    any method is welcome,either through functions or procedures.
    please do provide the solution

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    Simply access them in your trigger as follows

    <packagename>.<variablename> := value

    or

    if <packagename.variablename> = value then....

    I believe it is only in views that you need a wrapper function to get the values (ie you cannot access the variable directly).

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •