Cannot call oracle stored procedure and function?

If you want to execute a function you have to collect the return value into a variable So you need to define a variable and execute function to return into the variable as below and run it using the run Script option not the Run Statement option variable ret varchar2(20); execute :ret:=check_login(dd,dd); select :ret from dual Or if you do it from plsql declare v_ret varchar2(100); begin v_ret:=check_login(a,b); end.

If you want to execute a function you have to collect the return value into a variable. So you need to define a variable and execute function to return into the variable as below and run it using the run Script option not the Run Statement option. Variable ret varchar2(20); execute :ret:=check_login(dd,dd); select :ret from dual Or if you do it from plsql declare v_ret varchar2(100); begin v_ret:=check_login(a,b); end.

Thanks Joseph! That worked. Now, how to shrink the three lines to one line only so that it can be called from PHP code in one line using oci_execute()?

– kush. Impetus Oct 12 at 7:59 The second block you mentioned, works but only displays anonymous block completed. Does not return a value.

– kush. Impetus Oct 12 at 8:04.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.