date params with oracle

[morfo]

I have a stored procedure in oracle data base, so i need to run it from php4.

But i have a problem when send the params to the DB.

this is a source :

$sth = OCIParse ( $dbh, "begin RP_WAGNT(:REPORT_ID,😮FFICEID,:FROMDATE);end;" );
OCIBindByName ( $sth, ":REPORT_ID", $preport_id, 10 );
OCIBindByName ( $sth, "😮FFICEID", $pofficeid, 10 );
OCIBindByName ( $sth, ":FROMDATE", $pfromdate, 10); <--- i need help here
OCIExecute ( $sth );

Thanks...

[Anon]

What kind of help do you need? Are you getting a particular error message? What are the parameters of the Oracle procedure declared as (both datatype and mode (IN, OUT, INOUT))?

The first thing you will probably want to fix is how you are referencing your PHP variables: (note the "&")
OCIBindByName($sth, ":REPORT_ID", &$preport_id, 10);

-- Michael
Darkstreak Consulting
www.darkstreak.com