| | |
| |
Active Server Pages asp search engine active server page asp application components tutorial CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
cant update oracle database thru stored procedure. |
|
From: |
glenn venzke |
|
Date: |
8/3/2000 11:43:28 AM |
|
IP: |
64.16.202.131 |
I am trying to update an oracle database through a stored procedure written by our database administrator. As I understand it, stored procedures can only be accessed in ASP through the Oracle drivers. When I run the following code, it executes w/o raising an error, but the record Im trying to change never gets updated. I have a deadline coming up and would like to have this solved ASAP.
The stored procedure on the database side is as follows:
CREATE OR REPLACE PROCEDURE DB_OWNER.BG_MOVE_SECTION (iUID in number, iParent in number, iOrder in number) AS
i number;
iOldParent ITB_BUYERS_GUIDE_T.SECTION_UID%TYPE;
iOldOrder ITB_BUYERS_GUIDE_T.ORDER_NBR%TYPE;
cOldParentText ITB_BUYERS_GUIDE_T.LOOKUP_TEXT%TYPE;
cNewParentText ITB_BUYERS_GUIDE_T.LOOKUP_TEXT%TYPE;
iNewLevel ITB_BUYERS_GUIDE_T.LEVEL_NBR%TYPE;
BEGIN
-- Check if child and Parent UID exists
select parent_uid, order_nbr INTO iOldParent, iOldOrder from itb_buyers_guide_t where section_uid = iUID;
select LOOKUP_TEXT, LEVEL_NBR + 1 into cNewParentText, iNewLevel from itb_buyers_guide_t where section_uid = iParent;
select LOOKUP_TEXT into cOldParentText from itb_buyers_guide_t where section_uid = iOldParent;
-- Compact Old section
update itb_buyers_guide_t
set lookup_text = cOldParentText || . || ltrim(to_char(order_nbr - 1,00)),
order_nbr = order_nbr - 1
where parent_uid = iOldParent
and order_nbr > iOldOrder;
-- Make Room in New Section
update itb_buyers_guide_t
set lookup_text = cNewParentText || . || ltrim(to_char(order_ |
|
|
|
|
|
|
