Bug or feature in SQL SP

[andreyp#Antispam@mapsitnA#e-vision-group.com]

Hi all.

In db2diag.log I found next record

2003-07-03-13.21.46.812000 Instance:DB2 Node:000
PID:2096(db2dari.exe) TID:3144 Appid:
base_sys_utilities sqle_isMappingNeeded Probe:10

Mapping is not defined for the following types:

2003-07-03-13.21.46.812001 Instance:DB2 Node:000
PID:2096(db2dari.exe) TID:3144 Appid:
base_sys_utilities sqle_isMappingNeeded Probe:20

Passed type: ec01 ?.


2003-07-03-13.21.46.812002 Instance:DB2 Node:000
PID:2096(db2dari.exe) TID:3144 Appid:
base_sys_utilities sqle_isMappingNeeded Probe:30

Signature type: c001 ?.


I try determine a problem through statement monitor without success. After
many hours problem was located inside sql sp code

procedure p1
...
declare v_param1 as bigint;
declare v_param2 as varchar;
call p2(v_param1); -- bug, need v_param2

but procedure p2 declared with

procedure p2 (in v_param varchar)


Procedure p1 is compiled without errors and warnings :-(

Andy

[Sean McKeough]

Er, sorry, responded too quickly my previous answer...in v7, this create
/exec will get by because call is not a compiled statement, in v8,
you'll get an error. (in v7, you can ever create a procedure a that
calls procedure b when procedure b is not cataloged...but not in v8).

andreyp#Antispam@mapsitnA#e-vision-group.com wrote:

> Hi all.
>
> In db2diag.log I found next record
>
> 2003-07-03-13.21.46.812000 Instance:DB2 Node:000
> PID:2096(db2dari.exe) TID:3144 Appid:
> base_sys_utilities sqle_isMappingNeeded Probe:10
>
> Mapping is not defined for the following types:
>
> 2003-07-03-13.21.46.812001 Instance:DB2 Node:000
> PID:2096(db2dari.exe) TID:3144 Appid:
> base_sys_utilities sqle_isMappingNeeded Probe:20
>
> Passed type: ec01 ?.
>
>
> 2003-07-03-13.21.46.812002 Instance:DB2 Node:000
> PID:2096(db2dari.exe) TID:3144 Appid:
> base_sys_utilities sqle_isMappingNeeded Probe:30
>
> Signature type: c001 ?.
>
>
> I try determine a problem through statement monitor without success. After
> many hours problem was located inside sql sp code
>
> procedure p1
> ..
> declare v_param1 as bigint;
> declare v_param2 as varchar;
> call p2(v_param1); -- bug, need v_param2
>
> but procedure p2 declared with
>
> procedure p2 (in v_param varchar)
>
>
> Procedure p1 is compiled without errors and warnings :-(
>
> Andy
>