Executing oracle store procedure using entity framework 5 -


store procedure 

create or replace procedure getcorporateaction( record_date in date, prc out sys_refcursor ) begin open prc select * hr.corporateaction recorddate = record_date; end;

calling sp using ef:

var corporateactions = db.getcorporateaction(recorddate);

error message = "ora-06550: line 1, column 8:\npls-00306: wrong number or types of arguments in call 'getcorporateaction'\nora-06550: line 1, column 8:\npl/sql: statement ignored"

kindly suggest me how rid out of problem.thanks in advance.

there couple of problems:

  1. the procedure being invoked takes 2 arguments 1 has been supplied. variable second parameter should given in call.
  2. this procedure being called. procedures not return value, you've coded call if function being called.

the call should like

db.getcorporateaction(recorddate, corporateactions);

share , enjoy.


Comments

Post a Comment

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

i make custom datepicker directive custom template. but have no idea how start building it... how include date data directive? i appreciate guide or give me advice work on more precisely. it might you! follow below steps html code sample: <label>birth date</label> <input type="text" ng-model="birthdate" date-options="dateoptions" custom-datepicker/> <hr/> <pre>birthdate = {{birthdate}}</pre> <script type="text/ng-template" id="custom-datepicker.html"> <div class="enhanced-datepicker"> <div class="proxied-field-wrap"> <input type="text" ui-date-format="yy-mm-dd" ng-model="ngmodel" ui-date="dateoptions"/> </div> <label> <button class="btn" type="button"><i class="icon-calendar"></i>
Read more

javascript - jQuery date picker - Disable dates after the selection from the first date picker -

<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>jquery ui datepicker - default functionality</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> $(function () { $("#datepicker1").datepicker(); }); </script> <script> $(function () { $("#datepicker2").datepicker(); }); </script> </head> <body> <p>date 1: <input type="text" id="datepicker1"></p> <p>date 2: <input type="t
Read more