Glotzfisch.de

CREATE OR REPLACE PROCEDURE write_log (
   error_id IN NUMBER
   ,msg     IN VARCHAR2
)
IS
PRAGMA AUTONOMOUS_TRANSACTION;

BEGIN
  insert into zzz_errors (timestamp, error_code, message) VALUES (SYSDATE,error_id,msg);
  commit;
END write_log
[...more...]				

update (
   SELECT * FROM temp_dim tableIn,
                 temp_dates dates1,
	         temp_dates dates2
   WHERE dates1.ID = tableIn.VALID_FROM
   AND   dates2.ID = tableIn.valid_to
   AND SYSDATE BETWEEN dates1.FULL_DATE AND dates2.full_dat
[...more...]				

As Ruud is not posting any new Clueless Explosions at the moment, I guess we will have to find a way to survive without... at least for the time being. I hope he's fine and just does not fi
[...more...]

foreach ($aline as $val) {
$bline[] = iconv("ISO-8859-1","UTF-8",$val);
}