Can I return values to PHP from an anonymous PL/SQL block?

Posted by RenderIn on Stack Overflow See other posts from Stack Overflow or by RenderIn
Published on 2010-06-01T21:42:32Z Indexed on 2010/06/02 0:23 UTC
Read the original article Hit count: 535

Filed under:
|
|
|

I'm using PHP and OCI8 to execute anonymous Oracle PL/SQL blocks of code. Is there any way for me to bind a variable and get its output upon completion of the block, just as I can when I call stored procedures in a similar way?

$SQL = "declare
something varchar2 := 'I want this returned';
begin
  --How can I return the value of 'something' into a bound PHP variable?
end;";

© Stack Overflow or respective owner

Related posts about php

Related posts about Oracle