Help with Oracle stored proc call

First: Perl old timer, but Oracle & dbi/Oracle dbd newbie.

I have to do this development in a very short amount of time, and need
an example of how to call a stored procedure.
Here is an example of a PL/SQL call to the stored proc I want to call
from Perl DBI

bug.bug_api.update_bug(
lv_rptno, -- p_rptno IN OUT NUMBER,
null, -- upd_date (only provide if concurrency check
necessary)
null, -- p_version VARCHAR2(15)
.....
0, -- release_id NUMBER
'N', -- reassign bug IN VARCHAR2(1)
lv_error_code, -- p_error_code IN OUT NUMBER
lv_error_mesg -- p_error_mesg IN OUT VARCHAR2(80)
);
IF (lv_error_code is null) THEN
commit;
else
rollback;
END IF;

How would you call it from Perl DBI? Please give me an exampe

Specific Questions:
1. Do I have to furnish ALL the parameters, or only the ones that I
want changed?
2. If all parameters are to be furnished, do they have to be in that
particular sequence?
3. how do I capture execution error, like they did above, but in Perl?

Thanks a million

.

Relevant Pages