This content has been marked as final. Show 3 replies
TimesTen supports PL/SQL and sequences but those need to be created and executed in TimesTen not in Oracle. TimesTen does not cache/sync PL/SQL procedures or sequences with Oracle DB.1 person found this helpful
thanks expert Chris.
If there are no compatibility problems between oracle procedure and timesten procedure
and sequence in timesten can keep being consistent with active-standby pair,
I can just recreate these procedures and sequences in timesten and delete them from oracle, right?
Hi 911261,1 person found this helpful
If there are no compatibility problems between oracle procedure and timesten procedureThere are a lot of restrictions for PL/SQL in TimesTen (TimesTen supports only 12 system packages, doesn't fully support LOBs, and etc.). All limits you can find in documentation (http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21639/toc.htm)
Basically, based on my experience, the migration PL/SQL code from Oracle to TimesTen could be very difficult sometimes, so I would advice you to read the TimesTen documentation first and then to check your code in Oracle DB for compatibility.
Additionally you can use ttSrcScan utility for checking you PL/SQL code for compatibility (a little example here - http://ggsig.blogspot.co.uk/2011/09/plsql-timesten-ttsrcscan.html).