Friday, May 1, 2009

Playing with ESB Schema-1

Need to get the list of Systems and its respective GUID's.

The ESB schema name to connect is ORAESB. You need to have the following information to connect to this schema:
1) Password
2) Hostname
3) Port

You can get the Hostname and Port details from the datasources.xml file.

SELECT name,guid,status FROM wf_systems WHERE name != 'BPELSystem'

No comments: