Just an idea, as I'm not really at home with PL/SQL: shouldn't your SQL procedure do something like

RETURN :id

somehwere ?