jkr Posted November 30, 2006 Share Posted November 30, 2006 Hi,hope someone can help me out with this. I'm having a hard time executing a statement in PHP (which works fine in SQL clients, e.g. sqlplus). I want to have a search result from a fulltext search (using the ctx_ddl package) put into a temporary table, with the keywords highlighted. The statement looks somewhat like this:[code]EXEC ctx_doc.markup('MY_BASIC_INDEX', 'my key/s', 'the keyword to highlight', 'MY_TEMPORARY_TABLE', 1, FALSE, 'HTML_NAVIGATE');[/code]The statement works very fine in SQLPlus, but when I execute it in PHP, I get the error ORA-24333 ("zero iteration count").[code]$sql = "EXEC ctx_doc.markup('MY_BASIC_INDEX', 'my key/s', 'the keyword to highlight', 'MY_TEMPORARY_TABLE', 1, FALSE, 'HTML_NAVIGATE')";$stmt = OCIParse($sql); // returns a good valueOCIExecute($stmt); // fails[/code]Any ideas?Regards,Jonas Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.