Toad World® Forums

Issue with my_codetester.post_set_result () as per the documentation


#1

Hi,

I am using code tester 2.6.3.983 version.

I am trying to do the Driving Tests With Test Data Tables. I am following the documentation. when I execute the my_codetester.post_set_result () (provided in doc), it is throwing error :

l_result qu_result_tp.qu_result_rt

:= qu_result_xp.g_results (

harness_guid_in) (result_universal_id_in) (iteration_in);

ERROR:

[Error] PLS-00382 (16: 13): PLS-00382: expression is of wrong type
[Error] PLS-00320 (23: 10): PLS-00320: the declaration of the type of this expression is incomplete or malformed


Can you please let me know how to fix this ?

CREATE OR REPLACE PACKAGE BODY XXEA_LAS_O.my_codetester

AS

PROCEDURE post_set_result (

universal_id_in IN qu_result_tp.universal_id_t,

result_universal_id_in IN qu_result_tp.result_universal_id_t,

harness_guid_in IN qu_result_tp.harness_guid_t,

result_status_in IN qu_result_tp.result_status_t,

iteration_in IN PLS_INTEGER,

description_in IN qu_result_tp.description_t)

IS

PRAGMA AUTONOMOUS_TRANSACTION;

c_no_suite_node CONSTANT qu_config.maxvarchar2 := ‘NOSUITE’;

l_result qu_result_tp.qu_result_rt

:= qu_result_xp.g_results (

harness_guid_in) (result_universal_id_in) (iteration_in);

l_test_case_key qu_result_xp.key_t;

l_tc_result qu_result_tp.qu_result_rt;

BEGIN

IF l_result.result_level = 0

THEN

IF iteration_in <> qu_result_xp.c_template_iteration

THEN

l_tc_result.name :=

qu_result_xp.dynamic_tc_name (l_result.parent_universal_id,

iteration_in);

ELSE

l_test_case_key :=

qu_result_xp.g_results_by_universal_id (

l_result.parent_universal_id);

l_tc_result :=

qu_result_xp.g_results (

l_test_case_key.harness_guid) (

l_test_case_key.result_universal_id) (

l_test_case_key.iteration);

END IF;

UPDATE betwnstr_test_data

SET latest_result = l_result.result_status

WHERE tc_name = l_tc_result.name

AND ( latest_result IS NULL

OR latest_result = qu_result_xp.c_success);

COMMIT;

END IF;

END post_set_result;

END;

/


#2

Hi,

please try to re-install repository and then run your tests again.