Output from stored procedures

[Stevenn]

I am trying to use some stored procedures in Oracle. I've tried to use the upload-function with

objConnection.Execute "BEGIN upload_from_excel(1, 2, 3 ,4); END;"

, but I don't know how to get any response if the query didn't run successfully. Is there a way to do this in VBA?

I've found that I can use another stored procedure; validate_excel_upload(). How can I get the output from validate_excel_upload() in VBA? I've tried

objRecordset.Open "CALL validate_excel_upload(1, 2, 3, 4);"

and

MsgBox objRecordset(0)

, but I know it's a wrong way to use stored procedures. Can anyone please help me using stored procedures correctly? Thank you.

Btw the validate function looks like

PROCEDURE validate_excel_upload(p_delete IN NUMBER, p_budget_id IN NUMBER, p_upload_id IN NUMBER, p_user IN VARCHAR2, p_result OUT VARCHAR2);