|
Обьекты и функции
|
|||
---|---|---|---|
#18+
что я делаю не так? create or replace function COI_get_oxa return oxa_tab is lsd_obj oxa_obj; lsdvalue oxa_tab := oxa_tab(); n integer; begin for lsd_cur in (select p.payercode,pi.payerinfoname,pi.payerinfophones, s.streetname,h.housenum,h.houseextranum,f.flatnum,f.flatextranum, ag.agreetempldate,ag.agreetemplmeterage from payer p,payerinfo pi,flat f, house h,street s, agreetempl ag where ag.payerid=p.payerid and pi.payerid=p.payerid and f.flatid=p.flatid and h.houseid=f.houseid and s.streetid=h.streetid) loop n:=n+1; lsdvalue.extend; lsd_obj.ls :=lsd_cur.payercode; <-ругается на это lsd_obj.fio :=lsd_cur.payerinfoname; lsd_obj.tel :=lsd_cur.payerinfophones; lsd_obj.ulica :=lsd_cur.streetname; lsd_obj.dom :=lsd_cur.housenum; lsd_obj.dome :=lsd_cur.houseextranum; lsd_obj.kv :=lsd_cur.flatnum; lsd_obj.kve :=lsd_cur.flatextranum; lsd_obj.ddate :=lsd_cur.agreetempldate; lsd_obj.dvalue :=lsd_cur.agreetemplmeterage; lsd_obj.pdate :=null; lsd_obj.pvalue :=null; lsd_obj.mnum :=null; lsd_obj.mname :=null; lsd_obj.mdim :=null; lsdvalue(n) :=lsd_obj; end loop; Запрос: select ls from table(cast(COI_get_oxa() as oxa_tab)) ... |
|||
:
Нравится:
Не нравится:
|
|||
12.11.2002, 11:52 |
|
|
start [/forum/topic.php?fid=52&fpage=2833&tid=1992764]: |
0ms |
get settings: |
10ms |
get forum list: |
14ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
23ms |
get topic data: |
11ms |
get forum data: |
2ms |
get page messages: |
30ms |
get tp. blocked users: |
1ms |
others: | 253ms |
total: | 350ms |
0 / 0 |