|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
cant update oracle database thru stored procedure. - part 2 |
|
From: |
glenn venzke |
|
Date: |
8/3/2000 11:47:43 AM |
|
IP: |
64.16.202.131 |
My previous message got cut off in the middle.
Heres the rest:
update itb_buyers_guide_t
set lookup_text = cNewParentText || . || ltrim(to_char(iOrder,00)),
parent_uid = iParent,
order_nbr = iOrder,
level_nbr = iNewLevel
where section_uid = iUID;
bg_update_child(iParent);
bg_update_child(iOldParent);
commit;
END;
The code Im using in my asp page is as follows:
set OraSession = CreateObject("OracleInProcServer.XOrasession")
set OraDatabase = OraSession.DbOpenDatabase("MBO", "db_owner/mbo", 0)
OraDatabase.DbExecuteSQL("begin bg_move_section(104, 103, 3); end;")
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
