Page 1 of 1

stored procedure with return value

Posted: Thu Jul 20, 2006 2:32 am
by Zoran_Dimov
Pimptastic | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


I am trying to call the stored procedure CHECKSECURE_WEBSERVICE in ORACLE with the folowing PL/SQL command in PHP

Code: Select all

$s = ociparse($c, "begin :bind= CHECKSECURE_WEBSERVICE(:bind1, :bind2, :bind3, :bind4); end;")  or die("No parse");	   
	   
  
  OCIBindByName($s, ":bind1", $user) or die("No bind");
  OCIBindByName($s, ":bind2", $pass) or die("No bind");
  OCIBindByName($s, ":bind3", $bez_kod) or die("No bind");
  OCIBindByName($s, ":bind4", $sesID) or die("No bind");
  OCIBindByName($s, ":bind", $broj, 100) or die("No bind");

  $rez=ociexecute($s, OCI_DEFAULT);  or die("No exec");
The last command ociexecute can not bi executed.
Am i wrong with the PL/SQL syntax??

Thanks in advance


Pimptastic | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]