Jump to content

jkr

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

jkr's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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 value OCIExecute($stmt); // fails [/code] Any ideas? Regards, Jonas
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.