Dienstag, 27. Oktober 2009

ML-fun

ERR-7620 Could not determine workspace for application ()
sometimes it's really funny to see error messages.
This ony I got today:
I think, I'm missing my workspace (or is it the application, who knows ...)
Maybe this is only because of the ongoing transition phase and within the next days everything will be better...

Freitag, 2. Oktober 2009

xplan 2.1.3 is out

Alberto Dell'Era released a ne version of his xplan utility. Version 2.1.3 is out now.
Why is it's worth to mention?
1st he fixed a problem I faced within extraordinary speed (< 4 hrs!):


declare /* xplan_exec_marker */ *** error before main block (
processing XPLAN_OPTIONS ) *** -- main block
*
ERROR at line 1:
ORA-06550: line 1, column 34:
PLS-00103: Encountered the symbol "*" when expecting one of the following:
begin function pragma procedure subtype type <an identifier>
<a double-quoted delimited-identifier> current cursor delete
exists prior

--in setup.lst it's this error:

declare /* xplan_exec_marker */ -- process options
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 28


and 2nd: he didn't even announce it himself, so someone must do it :)