Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Start MS-excel from oracle on clientPC
if you are using forms, you can use the DDE and OLE handlers to do this.
There are examples on metalink. you cannot do this in a web environment.
absolutely has to be on client server mode.
to do it in web mode you need to run excel off the server and show it to the user.
"Siebe Jongebloed" <s.jongebloed_at_chello.nl> wrote in message
news:pSDV8.341238$yP6.13233381_at_Flipper...
> Hi there,
>
> I would like to combine functionality of Oracle and Excel.
>
> The idea is to use Oracle-Table-records-columns inside excel-spreadsheet
to
> calculate new values of other Oracle-Table-records-columns. The
spreadsheet
> itself should also reside inside a Oracle-'BLOB' with information on
which
> Oracle-source-records are used inside the excel-spreadsheet.
>
> A trigger inside Oracle should cause
>
> 1.. a particularly spreadsheet be sent to a oracle-client machine,
> 2.. start excel,
> 3.. update target values,
> 4.. as soon as source-records have changed.
> 5..
> How is this possible?
>
>
>
> Thanks in advance.
>
>
>
> Siebe.
>
>
>
Received on Sat Jul 06 2002 - 19:30:56 CDT