scan sql

[misuk11]

i have TOracleQuery component pointing to an oracle package. There are multiple variables (both in and out) as below

p_p_id IN INT,
p_source IN INT,
p_title OUT prg.epg_title%TYPE,
p_desc OUT prg.epg_description%TYPE,
p_group OUT prg.grouped_flag%TYPE,
p_type OUT INT,
p_ppv_desc OUT prg.epg_ppv_description%TYPE,
p_sound OUT prg.epg_sound_type%TYPE,
p_cert OUT object_external_references.external_reference%TYPE,
p_genre OUT object_external_references.external_reference%TYPE,
p_ca OUT prg.epg_ca_template%TYPE,
p_new_show OUT prg.epg_new_show_flag%TYPE,
p_critics OUT prg.epg_critics_choice_flag%TYPE,
p_sort OUT prg.epg_sort_title%TYPE,
p_si_desc OUT VARCHAR2,
p_nib_1 OUT object_external_references.external_reference%TYPE,
p_nib_2 OUT object_external_references.external_reference%TYPE,
p_nib_3 OUT object_external_references.external_reference%TYPE,
p_nib_4 OUT object_external_references.external_reference%TYPE,
p_si_ca OUT prg.si_ca_mode_flag%TYPE,
p_si_cert OUT object_external_references.external_reference%TYPE);

the SQL in the TOracle componet is as follows

BEGIN
C2_EPG.sp_check_epg_prog(
_p_id,
_source,
_title,
_desc,
_group,
_type,
_ppv_desc,
_sound,
_cert,
_genre,
_ca,
_new_show,
_critics,
_sort,
_si_desc,
_nib_1,
_nib_2,
_nib_3,
_nib_4,
_si_ca,
_si_cert);
END;

when i scan the sql in the vriable editor, all the variables are shown as strings when clearly some are integers, numbers, etc. is this by design or am i doing something wrong ?

tia
mark

 

[Marco Kalter]

This is by design. The scan function does not attempt to determine the variable types, and declares them as string by default. You will have to override the data types.