Open-For Cursor Not Returning Records
Hi
Arrgghh!
I'm writing a purge of tables who have DEATH_PATCH columns. I want to pass records from purge_tables_cur to cursor crow for bulk fetch and deletion. I've removed loops and dbms_output.put_line(see below for output) etc for simplicity.
This works - no errors - but returns no records to cursor crow, and there are millions. When I enable --USING v_table on to OPEN crow FOR v_stmt_str statement it fails with ORA-01006: bind variable does not exist.
Been working on this for 4 days and I'm about to give - help!!
Thanks in advance, Jamie
Arrgghh!
I'm writing a purge of tables who have DEATH_PATCH columns. I want to pass records from purge_tables_cur to cursor crow for bulk fetch and deletion. I've removed loops and dbms_output.put_line(see below for output) etc for simplicity.
This works - no errors - but returns no records to cursor crow, and there are millions. When I enable --USING v_table on to OPEN crow FOR v_stmt_str statement it fails with ORA-01006: bind variable does not exist.
Been working on this for 4 days and I'm about to give - help!!
Thanks in advance, Jamie
0