The script above will do that, call the stored proceure proc with the envirionemnt variable as it's parameter.
go to the oracle clinic Quick and easy Oracle database support and consulting
Forum Rules