Basic PHP & Oracle Problem

[kkelly]

Hi,

(Please note I do Oracle work!!)

I am using php script to query a function on our oracle db. The purpose of this function is to change the users pw.

Now the following works both in php & sql developer;

$s = oci_parse($c, "Select $User,$Password,$ConfirmPW from dual");

However the following doesnt work and gives the message below;

$s = oci_parse($c, "select bi_data.cbg_password_change('$User', '$User', '$User') A from dual")

Warning: oci_execute() [function.oci-execute]: ORA-00904: : invalid identifier in C:\xampplite\htdocs\login_test.php on line 21

However if I echo the statement out it works in sql developer fine, is there an escape character or something I'm using?

Thanks any help!

Edit fixed!!

select bi_data.cbg_pass('$User', '$User', '$User') A from dual") - Worked didnt seem to like the long function name