plsql - ORACLE PL/SQL: Table or view does not exist -


i'd appreciate on topic since making first steps pl/sql:

when trying create function, error: "table or view not exist" 5 select statements (and statement in cursor declaration well). sure tables exist.

many in advance.

create or replace function zinskalk (vtid in number, intart in integer)    return number    j         integer := 0;    p         number := 1;    q         number := 0;    t         number := 1;    r         number := 0;    lz        integer := 0;    modusvn   integer := 0;    w1        number := 0;    w2        number := 0;            integer := 0;     type array_typ varray (200) of number (10, 2);     rarray    array_typ;     cursor c1            select vtobslpos.anzahl, vtobslpos.betrag           vtobsl, vtobslpos              vtobsl.sysid = vtobslpos.sysvtobsl                , vtobsl.sysid in                       (select max (vtobsl.sysid)                          vtobsl                         vtobsl.sysvt = vtid , vtobsl.rang = 100)       order vtobslpos.rang asc;  begin    select sum (vtobslpos.anzahl)      lz      vtobslpos, vtobsl         vtobslpos.sysvtobsl = vtobsl.sysid           , vtobsl.sysvt = vtid           , vtobsl.sysid in (select max (sysid)                                  vtobsl                                 sysvt = vtid , rang = 100);     select vtobsl.modus      modusvn      vtobsl     vtobsl.sysid in (select max (sysid)                              vtobsl                             sysvt = vtid , rang = 100);     select   bgextern           - sz           + (case intart                 when 1 0                 when 2 - (sz2 + disagio)                 when 3 (sz2 + disagio - provision)                 else 0              end)      w1      vt     sysid = vtid;     select rw + rsv      w2      vt     sysid = vtid;     := (case when modusvn = 0 1 else 0 end);     rarray (1) := -w1;    rarray (lz + 1) := w2;     x in c1    loop       y in 1 .. x.anzahl       loop          := + 1;          rarray (i) := rarray (i) + x.betrag;       end loop;    end loop;       while abs (p) >= 0.001    loop       p := 0;       q := 0;       j := 0;        z in 1 .. lz + 1       loop          j := j + 1;          p := p + rarray (j) * power (t, j - 1);          q := q + (j - 1) * rarray (j) * power (t, j - 2);       end loop;        t := t - p / q;    end loop;     r := 1200 / t - 1200;    return r; exception    when others          return 0; end;

i assume table belong schema schema function compiled. if have granted select on these table via role rather directly, oracle give ora-00942.

see this stackoverflow question more information.


-

Comments

Post a Comment

Popular posts from this blog

php - regexp cyrillic filename not matches -

i take list of files php glob(."*.pdf") . files have cyrillic names. example: ООО «Рога и копыта» then load company names database , try find them in file names: preg_match("/$firm_name/ui", $file_name, $match); i have problem: firms if $firm_name visually similar $file_name , preg_match says there no match. mb_detect_encoding both variables return utf-8. there problem in file name, or maybe there encoding or something, can not understand, ask help. upd: $file_name='ООО «Рога и копыта»'; preg_match("/... .Рога и копыта./ui", $file_name, $match); as result, ОО «Рога и копыта» , 1 О missing
Read more

c# - OpenXML hanging while writing elements -

Image
i have program pulls data database, caches file , exports data multiple formats (excel, excel 2003, csv). i'm using openxml sdk 2.0 excel work. these export processes run in parallel (using parallel.foreach ), , amount of data can pretty large - e.g. csvs 800mb. during these larger exports, i've noticed writing of xml documents hang. instance, if have 8 exporting in parallel, @ point "pause". hang around same point: //this.writer openxmlwriter created worksheetpart. this.writer.writeelement(new cell() { cellvalue = new cellvalue(value), datatype = cellvalues.string }); when happens, pause debugger (vs2013 in case) , notice threads blocking around same portion of code - bit deeper in openxml sdk - stem call openxmlwriter.writeelement . i dug through source using justdecompile didn't find answers. appears there intermediary stream in use writing isolated storage , is, reason, blocking. underlying stream each of these filestream . here screenshot ...
Read more

sql - Select Query has unexpected multiple records (MS Access) -

i may tired, can't seem figure out happening. have 2 queries. query 1 has 10 fields. query 2 has 5 fields. fields 1 through 3 same in both queries. trying write select query , simple add field 5 query2 query1 result should query1 additional field (query2.field5). i join first 3 fields both queries , choose select records in query1 , in query2 match. don't know sql, use query designer. expect same number of records have query 1 instead have 3 times or more. can tell me doing wrong. tried reversing joins still seem same records. thanks in advance. here query: the fields in common divisionname , supplierid = vendorid , commodityname . select [part revenue exposed query p1].divisionname, [part revenue exposed query p1].commodityname, [part revenue exposed query p1].suppliername, [part revenue exposed query p1].partnumber, [part revenue exposed query p1].partdescription, [part revenue exposed query p1].bucode, ...
Read more