Previous | Next
Topic: utplsql on Linux
Conf: 537, Msg: 40078
From: Cristi Petrescu-Prahova (cristipp@excite.com)
Date: 12/16/00 09:01 AM

utplsql on Linux Cristi Petrescu-Prahova cristipp cristipp@excite.com First query:

SQL> SELECT SUBSTR(version,1,3) col
FROM product_component_version
WHERE UPPER(product) LIKE 'ORACLE7%'
OR UPPER(product) LIKE 'PERSONAL ORACLE%'
OR UPPER(product) LIKE 'ORACLE8%';

2 3 4 5
COL
---
8.1

Second query(ies):
SQL> @show 336

LINE_OF_CODE
--------------------------------------------------------------------------------
331 THEN
332 pl ('Compile Error "' || SQLERRM || '" on: ');
333 pl (v_str);
334 END IF;
335
336 utAssert.this (
337 'Unable to run ' || v_pkg || '.' || v_name || ': ' ||
338 SQLERRM,
339 FALSE,
340 null_ok_in => NULL,
341 raise_exc_in => propagate_in,
SQL> @show 623

LINE_OF_CODE
--------------------------------------------------------------------------------
618
619 PROCEDURE cleanup IS
620 BEGIN
621 utresult.show;
622
623 runprog (v_prefix || c_teardown, TRUE);
624
625 utpackage.upd (suite_in,
626 package_in,
627 v_start,
628 SYSDATE,
SQL> @show 687

LINE_OF_CODE
--------------------------------------------------------------------------------
682 THEN
683 utAssert.this (
684 'utPLSQL.test failure: ' || SQLERRM,
685 FALSE);
686
687 cleanup;
688 END;
689
690 PROCEDURE testsuite (
691 suite_in IN VARCHAR2,
692 recompile_in IN BOOLEAN := TRUE,
SQL>

I'm still lost ;-)
Maybe you have a clue.
Thanks,
Cristi