How to use a php variable in PL/SQL statement in Oracle

Question

I am trying to use a PHP variable instead of using Oracle Variable. Now the code is as follows:

declare
    V_EXAMCAT_MAP_ID varchar2(16);
begin
    PRC_BUILD_PK ('', 'SEQ_NM_APPLICATION', 'T', '1', V_EXAMCAT_MAP_ID,'Y');
end;
/

Now in the above code, V_EXAMCAT_MAP_ID is returning T180801000010 I want to use PHP variable instead of V_EXAMCAT_MAP_ID to get the result in a PHP variable of the procedure.

Is it possible? if possible please help me

check this article oracle.com/technetwork/articles/fuecks-sps-095636.html — hotfix
– hotfix, Commented Aug 7, 2018 at 10:43
duplicate of cant get out parameter from stored procedure using php — Kaushik Nayak
– Kaushik Nayak, Commented Aug 7, 2018 at 13:31

Christopher Jones · Accepted Answer · 2018-08-20 03:26:54Z

1

See "Binding Parameters in PL/SQL Procedure Calls" on p192 of the free http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html

For example, to get a string from a PL/SQL procedure 'OUT' parameter, you would use something like:

$s = oci_parse($c, "begin toyshop.find_toy_proc(:id, :name); end;");
$id = 1;
oci_bind_by_name($s, ":id", $id);
oci_bind_by_name($s, ":name", $name, 40);
oci_execute($s);
echo "Name is: ".$name;

answered Aug 20, 2018 at 3:26

Christopher Jones

11.1k7 gold badges32 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use a php variable in PL/SQL statement in Oracle

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related