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

PHPMotion implementation - URL based videos (Hosted on separate location) -

-
i have implement video collection website users of specific isp. site hosted on public web-server movies hosted on local isp server. user of isp + general visitors can see available movies; isp's users able play them. player on site point url of local machine ( http://192.x.x.x/movies/mymovie.mov ) private class (192.x.x.x) accessible isp user. question: possible phpmotion script? or need custom work. if possible, can please suggest available mods? phpmotion require modifications able handle this. uploading, conversion, thumbnail generation, , playback pretty static in phpmotion. really though, rather modding entire upload , conversion process, if created quick custom form add entries phpmotion database (maybe include thumbnail upload), tweaked playback paths, should go on phpmotion side of things. assume had videos in format player handle (such flv or mp4).
Read more

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

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