@org

This script will give you a list of all org_id’s – or just those matching the parameter. Copy paste the client_nfo column to set client info. SQL> @org % ORG_ID NAME                         CLIENT_INFO ------ ---------------------------- -----------------------------------------------------      0 Setup Business Group         begin dbms_application_info.set_client_info(0);end;    101 XXXX GROUP                   begin dbms_application_info.set_client_info(101);end; Syntax: @org <partial org. name>    @org (0 downloads)

Leave a Reply