Re: Oracle In-Memory Database Cache and PL/SQL
Date: Sun, 25 Jul 2010 16:06:16 +0200
Message-ID: <AANLkTi=r3fYV0g7BHJowg3vsWyXkdKgOv9FW8383dbDg_at_mail.gmail.com>
Oracle Times Ten supports PL/SQL
http://download.oracle.com/otn_hosted_doc/timesten/1121/quickstart/html/developer/plsql/plsql.html but not all data types and functions are supported yet, also many packages are missing.
unfortunately a simple 'compile' and 'show error' will not be sufficient. you have to test every code manually.
hth
Martin
On Thu, Jul 22, 2010 at 07:47, Matt McClernon <mccmx_at_hotmail.com> wrote:
>
> I�m in the process of doing a proof of concept with IMDB to
> cache a subset of our application data to improve the performance of our application.
>
>
>
> I�ve hit a problem which I think makes the product
> unsuitable in our current environment and I was wondering if I�m missing
> something in the research I�ve done.
>
>
>
> Does IMDB allow the caching (and execution) of stored pl/sql
> packages and types which are stored in the main Oracle database..?
>
>
>
> Based on the research I�ve done it only appears as though
> IMDB can cache table data.� I have seen evidence of the ability to create
> pl/sql stored units independently in IMDB but no mention of caching and
> executing existing pl/sql units that live in the RDBMS.
>
>
>
> If IMDB is restricted to table data then our application
> would effectively have to go to the RDBMS to execute the pl/sql code and then back
> to the IMDB layer to read the �cached� table data which seems to be
> counter-productive.
>
>
>
> Is this the case or am I missing something..?
> _________________________________________________________________
> http://clk.atdmt.com/UKM/go/195013117/direct/01/
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Martin Berger� � � � �� martin.a.berger_at_gmail.com Lederergasse 27/2/14� � � � �� +43 660 660 83306 1080 Wien� � � � � � � � � � � � � � � � � � �� http://berx.at/ -- http://www.freelists.org/webpage/oracle-lReceived on Sun Jul 25 2010 - 09:06:16 CDT