SQL & PL/SQL

Hi there!

I keep getting an ORA-01001 on a straight forward SELECT .. INTO statement and I just don't understand why. All the common causes for ORA-01001 don't apply as this is an implicit cursor where I can't do anything wrong with OPEN, CLOSE etc.

This is the code block that throws the exception:

BEGIN

SELECT nvl(rc.status, c_status_wfi_error) AS status,
nvl(rc.description, nvl(p_status_string, 'Unknown Error')) AS description
INTO l_status, l_description
FROM w_items_2_workflows iw
LEFT JOIN w_wfitems_wf_return_codes rc
ON (rc.workflowitems_2_workflow = iw.id)
WHERE iw.workflow = rec_d_workflow.workflow
AND iw.workflowitem = p_workflowitem
AND iw.scenario = rec_d_workflow.scenario
AND rc.return_code = l_return_code;

EXCEPTION
WHEN OTHERS THEN
p_error_message := aax_zentral.get_error_message(737) || ' (' ||
to_char(l_return_code) || '/workflow:' ||
to_char(rec_d_workflow.workflow) ||
'/workflowitem:' ||
to_char(p_workflowitem) || '/scenario:' ||
to_char(rec_d_workflow.scenario) || '/id:' ||
to_char(rec_d_workflow.id) || ') ' ||
to_char(SQLCODE) || ' - ' || SQLERRM;

RAISE aax_zentral.ex_others;
END;

Any ideas?

You would make a desperate man very happy ;)

Cheers
Volker