oracle - SQL Package Syntax Error -

-

i having problem locating error on tapi built "project table". syntax error because not compile, posted code , errors below... if lead me in right direction appreciated.

code 

create or replace package body "project_tapi" -------------------------------------------------------------- -- create procedure table "project" procedure "ins_project" (   "p_startdate" in date              default null,   "p_projid"    in number,   "p_empno"     in number            default null,   "p_projname"  in varchar2          default null )   begin    insert "project" (      "startdate",      "projid",      "empno",      "projname"   ) values (       "p_startdate",      "p_projid",      "p_empno",      "p_projname"   );  end "ins_project"; -------------------------------------------------------------- -- update procedure table "project" procedure "upd_project" (   "p_projid" in number,   "p_startdate" in date              default null,   "p_empno"     in number            default null,   "p_projname"  in varchar2          default null,   "p_md5"       in varchar2          default null )     "l_md5" varchar2(32767) := null;  begin    if "p_md5" not null      c1 in (         select * "project"          "projid" = "p_projid" update      ) loop          "l_md5" := "build_project_md5"(            c1."startdate",            c1."projid",            c1."empno",            c1."projname"         );       end loop;    end if;    if ("p_md5" null) or ("l_md5" = "p_md5")       update "project" set         "startdate"   = "p_startdate",         "projid"      = "p_projid",         "empno"       = "p_empno",         "projname"    = "p_projname"      "projid" = "p_projid";   else      raise_application_error (-20001,'current version of data in database has changed since user    initiated update process. current checksum = "'||"l_md5"||'", item checksum = "'||"p_md5"||'".');     end if;  end "upd_project"; -------------------------------------------------------------- -- delete procedure table "project" procedure "del_project" (   "p_projid" in number )   begin    delete "project"    "projid" = "p_projid";  end "del_project"; -------------------------------------------------------------- -- procedure table "project" procedure "get_project" (   "p_projid" in number,   "p_startdate" out date,   "p_empno"     out number,   "p_projname"  out varchar2 )     ignore varchar2(32676); begin    "get_project" (      "p_startdate",      "p_projid",      "p_empno",      "p_projname",      ignore   );  end "get_project"; -------------------------------------------------------------- -- procedure table "project" procedure "get_project" (   "p_projid" in number,   "p_startdate" out date,   "p_empno"     out number,   "p_projname"  out varchar2,   "p_md5"       out varchar2 )   begin    c1 in (      select * "project"       "projid" = "p_projid"    ) loop      "p_startdate" := c1."startdate";      "p_empno"     := c1."empno";      "p_projname"  := c1."projname";       "p_md5" := "build_project_md5"(         c1."startdate",         c1."projid",         c1."empno",         c1."projname"      );   end loop;  end "get_project"; -------------------------------------------------------------- -- build md5 function table "project" function "build_project_md5" (   "p_projid" in number,   "p_startdate" in date              default null,   "p_empno"     in number            default null,   "p_projname"  in varchar2          default null,   "p_col_sep"   in varchar2          default '|'  ) return varchar2    begin    return sys.utl_raw.cast_to_raw(sys.dbms_obfuscation_toolkit.md5(input_string=>       "p_startdate" ||"p_col_sep"||      "p_empno"     ||"p_col_sep"||      "p_projname"  ||"p_col_sep"||      ''   ));   end "build_project_md5";  end "project_tapi";

error 

compilation failed,line 46 (21:08:15) pls-00306: wrong number or types of arguments in call 'build_project_md5'compilation    failed,line 46 (21:08:15) pls-00306: wrong number or types of arguments in call 'build_project_md5'compilation failed,line 46 (21:08:15) pl/sql: statement ignoredcompilation failed,line 93 (21:08:15) pls-00306: wrong number or types of arguments in call 'get_project'compilation failed,line 93 (21:08:15) pl/sql: statement ignoredcompilation failed,line 122 (21:08:15) pls-00306: wrong number or types of arguments in call 'build_project_md5'compilation failed,line 122 (21:08:15) pls-00306: wrong number or types of arguments in call 'build_project_md5'compilation failed,line 122 (21:08:15) pl/sql: statement ignored

thanks

there lot wrong calling of methods.

for example one:

 "p_md5" := "build_project_md5"(     c1."startdate",     c1."projid",

the order of fields wrong. should other way around.


Comments

Post a Comment

Popular posts from this blog

c# - Unity IoC Lifetime per HttpRequest for UserStore -

-
i'm trying clean default implementation of accountcontroller.cs comes out of box in new mvc5/owin security implementation. have modified constructor this: private usermanager<applicationuser> usermanager; public accountcontroller(usermanager<applicationuser> usermanager) { this.usermanager = usermanager; } also, have created lifetime manager unity looks this: public class httpcontextlifetimemanager<t> : lifetimemanager, idisposable { private httpcontextbase _context = null; public httpcontextlifetimemanager() { _context = new httpcontextwrapper(httpcontext.current); } public httpcontextlifetimemanager(httpcontextbase context) { if (context == null) throw new argumentnullexception("context"); _context = context; } public void dispose() { this.removevalue(); } public override object get...
Read more

Change the color of an oval at click in Java AWT -

-
i have draw ovals in java, , @ click change color. beginning tried change color after 20 ms, doesn't work. my code is: public class mycomponentnew extends frame { public graphics2d g2d; public mycomponentnew(string title) { super(title); setsize(400, 550); } @override public void paint(graphics g) { this.g2d = (graphics2d) g; this.g2d.setcolor(color.red); this.g2d.filloval(10, 55, 50, 100); } public void changecolor () { this.g2d.setcolor(color.blue); this.g2d.filloval(10, 55, 50, 100); } } and in class main method have: mycomponentnew m; m = new mycomponentnew("fereastra cu baloane"); m.setvisible(true); m.addwindowlistener(new windowadapter() { @override public void windowclosing(windowevent we) { system.exit(0); } }); try { thread.sleep(20); } catch(interruptedexception e) {} m.changecolor(); the color of oval remains red. ...
Read more

I am trying to solve the error message 'incompatible ranks 0 and 1 in assignment' in a fortran 95 program. -

-
i writing program in fortran find velocity of parachuting person in relation time. keep getting error can't fix. new programming , appreciated. the error is v(i+1)=v(i)+[32-((c*v(i)*v(i))/m)]*(h) 1 error: incompatible ranks 0 , 1 in assignment @ (1) and program is program para integer :: real :: v(11) !velocity real :: q !initial velocity real :: h !time step real :: c !drag coefficient real :: m !mass ! gravity equal 32 ft/s^2 write (*,*)'enter time step' read(*,*)h write(*,*)'enter initial velocity' read(*,*)q write(*,*)'enter drag coefficient' read(*,*)c write(*,*)'enter mass' read(*,*)m i=1,10 ! 1 10, 1 being interval. end v(i+1)=v(i)+[32-((c*v(i)*v(i))/m)]*(h) q=v(1) end program you cannot use [] normal parenthesis in expressions. array constructor, [ items ] means array items elements. end do should after line.
Read more