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