Hi
how about Java within Oracle. What do you think about it ?
When does it make sense to use Java instead of PL/SQL ?
The problem is that I dislike a mix of different languages
within an application. It messes things up.
But maybe it makes sense to use PL/SQL for most stuff and
Java for some
Hi Roland,
You can implent something like this:
sERROR_TEXT := 'execute P1 failed';
exec P1;
---
IF SQLCODE != 0 THEN
sERROR_CODE := -20005;
sERROR_TEXT := 'execute P1 failed. Oracle Error Number:: ORA' ||
SQLCODE || '-' || SQLERRM;
raise DATA_ERROR;
END IF;
---
Hi:
use the procedure:
dbms_lock.sleep(seconds);
HTH
--
Von: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
Gesendet: Freitag, 11. Mai 2001 17:20
An: Multiple recipients of list ORACLE-L
Betreff: PL/SQL Question
I need to whip out a PL/SQL procedure real quick today