rlove / pluto-test-framework Goto Github PK

What steps will reproduce the problem?
1. Create Pluto User/Grant create session + create type
2. run @install
3.

What is the expected output? What do you see instead?

Expected to install, actual output is.

SQL> show errors;
Errors for TYPE BODY PLUTO_OBJ:

LINE/COL ERROR
-------- -----------------------------------------------------------------
23/5     PL/SQL: Statement ignored
23/23    PLS-00201: identifier 'REGEXP_REPLACE' must be declared
SQL>
SQL> select case when status = 'INVALID' then 1/0 else 1 end
  2      did_the_object_compile
  3  from user_objects
  4  where object_name = 'PLUTO_OBJ'
  5    and object_type = 'TYPE BODY';
select case when status = 'INVALID' then 1/0 else 1 end
                                                    *
ERROR at line 1:
ORA-01476: divisor is equal to zero



What version of the product are you using? On what operating system?


Oracle 9i (9.2.0.5) Standard Edition - 64bit Solaris


Please provide any additional information below.

REGEXP_REPLACE is not available in version 9i or oracle.

select * from dba_objects where object_name= 'REGEXP_REPLACE'

OWNER                          OBJECT_NAME                                

          SUBOBJECT_NAME                 OBJECT_ID             
DATA_OBJECT_ID         OBJECT_TYPE        CREATED                  
LAST_DDL_TIME             TIMESTAMP           STATUS  TEMPORARY GENERATED
SECONDARY 
------------------------------
--------------------------------------------------------------------------------
------------------------------------------------
------------------------------ ----------------------
---------------------- ------------------ -------------------------
------------------------- ------------------- ------- --------- ---------
--------- 

0 rows selected

What steps will reproduce the problem?
Using sqlplus:

   m_util_object.is_ok(
      data_got        => var_got,
      data_expected   => var_expected,
      test_label     => 'Long message, nearly 255 characters....'
   );

What is the expected output? What do you see instead?
Expected: "Long message, nearly 255 characters...."
Instead: ORA-06502: PL/SQL: numeric or value error: host bind array too 
small 

What version of the product are you using? On what operating system?
download 00049. SQL*Plus: Release 10.1.0.4.2 on Windows XP. Oracle 10g2 on 
HP-UX.

Please provide any additional information below.
truncate messages to 255 chars to avoid sqlplus/dbms_output error: ORA-
06502: PL/SQL: numeric or value error: host bind array too small

=== (+4,-4) pluto-test-framework/sql/utilities/pluto_output_obj.pkb ===
@@ -32,17 +32,17 @@

     if test_passed = true then
       m_passed_test_count        := m_passed_test_count + 1;
-      dbms_output.put_line('pass - ' || test_label);
+      dbms_output.put_line(substr('pass - ' || test_label,1,255));
     else
       m_failed_test_count        := m_failed_test_count + 1;
-      dbms_output.put_line('fail - ' || test_label);
+      dbms_output.put_line(substr('fail - ' || test_label,1,255));
       dbms_output.put_line( details );
     end if;
   end log_test_results;
 --
   member procedure log_message( message in varchar := '' ) is
   begin
-    dbms_output.put_line( message );
+    dbms_output.put_line( substr(message,1,255) );
   end log_message;
 --
   member procedure log_test_completion is

Is there a script / proper procedure required to uninstall PLUTO?

Regards
Neville Bonavia