Previous | Next
Topic: utplsql on Linux
Conf: 537, Msg: 40074
From: Cristi Petrescu-Prahova (cristipp@excite.com)
Date: 12/16/00 06:49 AM
utplsql on Linux Cristi Petrescu-Prahova cristipp cristipp@excite.com
Has anybody succeeded to install utplsql on Linux?
I am running Oracle 8.1.6 on Redhat 6.2.
I installed utplsql without any error.
I built the following package:
create or replace package ut_wlib_state as
procedure ut_setup;
procedure ut_teardown;
procedure ut_setup_state;
end ut_wlib_state;
/
show errors
create or replace package body ut_wlib_state as
--
procedure ut_setup is
begin
null;
end;
--
procedure ut_teardown is
begin
null;
end;
--
procedure ut_setup_state is
begin
utAssert.eq ('success', 'a', 'a');
utAssert.eq ('failure', 'a', 'abcd');
end;
--
end ut_wlib_state;
/
show errors
I am trying to run utplsql:
exec utplsql.autocompile (false);
exec utplsql.test ('wlib_state');
and all I get is an impenetrable error:
BEGIN utplsql.test ('wlib_state'); END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.STANDARD", line 67
ORA-06512: at "UTPLSQL.UTPLSQL", line 336
ORA-06550: line 1, column 7:
PLS-00103: Encountered the symbol "." when expecting one of the following:
begin declare exit for goto if loop mod null pragma raise
return select update while
<<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall
The symbol "" was substituted for "." to continue.
ORA-06512: at "UTPLSQL.UTPLSQL", line 623
ORA-06512: at "UTPLSQL.UTPLSQL", line 687
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
Does anybody know what's wrong?
Thanks,
Cristi