Hi,
I've the follow code in a php script:
function logIn() {
$conn = ociNLogon("user","pass");
/** The connection has made sucessfuly */
$sql="SELECT COUNT(*) INTO :nUsers FROM table_1";
$stmt = OCIParse($conn,$sql);
(*)ociBindByName($stmt,":nUsers",&$nUsers, 32);
$exec = ociExecute($stmt);
/** And a lot of PHP code below */
}
and when I run the script my blowser asware with:
Warning: OCIBindByName: ORA-01036: illegal variable name/number in testScript.php on line (*)
Could anyone help me with this?
I've allready try to initialize the variable 'nUsers' like 'nUsers = "0000"' and put the length in 'ociBindByName' -1, but neither like that it work.
Tks.