Re: OMS Question

From: Ronald Rood <devnull_at_ronr.nl>
Date: Fri, 8 Apr 2005 09:44:09 +0200
Message-ID: <0001HW.BE7C02E9007753DDF02845B0@news.individual.net>

On Fri, 8 Apr 2005 01:47:26 +0200, Bernd Renzing wrote (in article <d34gqf$fir$04$1_at_news.t-online.com>):

> Hello Ronald,
>
> Ronald Rood wrote:
>

>>> I want to use OMS for executing some SQL-Scripts (as Job) on each database.
>>> BUT I want to get some of the Results of these Scripts into a central 
>>> Table/Database

>

>> This can be done with scheduled reports and a piece of tcl code that 
>> converts 
>> the html table[s] to csv and sqlloader. Just start with a scheduled report 
>> and edit the job that gets created for it.

> I wonder if you or someone elisa have a example for the tcl part? I´m
> not very familar with tcl.
>
> If there is no example, I think I have to learn that tcl stuff.
>

Hi Bernd,

sure, I have but don't forget it's very custom built so you do have to learn some tcl for it in order to convert it to your needs.

With kind regards / met vriendelijke groeten, Ronald

http://ciber.nl
http://homepage.mac.com/ik_zelf/oracle Received on Fri Apr 08 2005 - 02:44:09 CDT