How to make PHP NOT consume OCI8 Errors.

[dlite922]

Hey Guys,

I'm finding that oci_error always returns false. When I did a test script:

 
 
$db = ocilogon('test', 'test', '//test:123/test.world');
$stmntID = oci_parse($db, "SELECT dec2hex(14 FROM dual");
oci_set_prefetch($stmntID, 1000);
$result = oci_execute($stmntID,OCI_COMMIT_ON_SUCCESS);
$data = oci_fetch_assoc($stmntID);
var_dump(oci_error($db));
 
 

I get PHP warnings. Of course if you have errors turned off you never see the errors.

Reason I needed is I need to display a message to the user if a certain ORA-XXXXX error occurs. I can't do that because oci_error always returns false. ALSO oci_execute returns false.

This is not right. is it?

My only solution at this point is to capture any and all PHP warnings and see which one starts with ORA-XXX.

If someone can "edumicate" me I'd appreciate it.

Thanks,


Dan

[dlite922]

EDIT: Disregard, see next message.

Commenting the line oci_set_prefetch() seems to make it work (although i'm using CodeIgniter and still having issues with it) but the test script above now displays the ORA error.

BUT I don't understand why that would erase the oci_error()? PHP DOCS make no mention of it that I see.

any clues?

[dlite922]

DISREGARD last Message:

It seems that different ORA- errors get reported in oci_error(), but ALL errors are reported to PHP as a warning.

This SQL will be caught in oci_error:

SELECT ' FROM dual; 
 
//ORA-01756: quoted string not properly terminated
 

This will not:

SELECT dec2hex(14 FROM dual; 
 
//ORA-00907: missing right parenthesis
 

Weird! What's so significantly different about them?

Any ideas?