stoed proc for oracle
From: Marcus Lloyd (MarcusLloyd_at_discussions.microsoft.com)
Date: 01/28/05
- Previous message: Brendan Reynolds: "Re: Access 2000 and VB 6"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 28 Jan 2005 12:27:03 -0800
Hi,
I would like to call a stored proc from Oracle. I have created the procedure
in Oracle and the connection to the database.
the code i've done is as follows:
OraStoredProc
(
v_doc_no in varchar2,
v_basic_part_no in varchar2,
v_bill_qty in number
)
as
begin
update bill_detail_analysis
set BILL_QTY = v_selfbill_qty
where DOCUMENT_NUMBER = v_doc_no and BASIC_PART_NO = v_basic_part_no;
commit;
end;
I would like to pass and update the qty field, also with the parameters.
OpenOracleConnection ora
ora.CursorLocation = adUseClient
cmd.ActiveConnection = ora
cmd.CommandText = _
"{CALL live.bill_update ({'AA-AA-AAAA','AA-AA -AAAA',10})}"
cmd.CommandType = adCmdStoredProc
cmd.Execute , , adExecuteNoRecords
I keep getting an error, can anyone help.
cheers
Marcus
- Previous message: Brendan Reynolds: "Re: Access 2000 and VB 6"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
