Rem
Rem $Header: cwm2vrq.sql 05-sep-2002.16:34:07 cdalessi Exp $
Rem
Rem cwm2vrq.sql
Rem
Rem Copyright (c) 2000, 2002, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      cwm2vrq.sql
Rem
Rem    DESCRIPTION
Rem      Install cwm/cwm2 version query function
Rem      Provides an interface to the user_registry version function
Rem
Rem    NOTES
Rem
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    glyon       06/04/07 - replace public with cwm_user in grant execute
Rem    cdalessi    09/05/02 - cdalessi_txn104184
Rem    cdalessi    08/28/02 - Creation
Rem


create or replace function 
  version ( comp_id in varchar2 := 'AMD' ) return varchar2
as
begin
  return sys.dbms_registry.version(comp_id);
end;
/
grant execute on version to CWM_USER;