|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components 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;")
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
