Click here to Skip to main content
15,888,208 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a procedure in oracle database same this:
C#
PROCEDURE   milad_101 ( INAMT IN  NUMBER ,RESULT_OUT OUT sys_refcursor  )
IS 
 begin
   
       open RESULT_OUT for   'select shenaseh,pardakhtkey,mablaghkol from LASTtable where  mablaghkol>='|| inAMT ;
 
     commit;
   
End; 



my webapi is:

C#
public string GetGis(Int64 id)
       {
            
           var res = db.milad_101( id);
          
           return (res).ToString();
       }


What I have tried:

when i run program ,visual studio show this error:
ORA-06550: line 1, column 8:
PLS-00306: wrong number or types of arguments in call to 'milad_101'
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
what do i please?
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900