HELP!! PL/SQL
From: DooHee Kim~ <4658291d_at_taurus.oac.uci.edu>
Date: Mon, 2 Aug 1999 21:42:51 -0700
Message-ID: <Pine.SOL.4.05.9908022137450.3559-100000_at_taurus.oac.uci.edu>
I'm using cookies to store the items in the shopping cart and when the user clicks on view shopping cart, I retrieve all the itmes in the shoppping cart thru owa_cookie.get_all.
All the item ID# and its quantities are stored in ck_names, and ck_vals respctively, which are both of type owa_cookie.vc_arr I want to retrive price and description of these items and can't figure out how to go about making the call to database. There two tables, one that has item price and another that has item description.
HOw can I go about using curosr to call the database once and retrive every price and description for items in shopping cart. I know waht should be done, it's just that I can't write it to work in pl/sql
For instance, since the number of items in shopping cart differ everytime, I can't use 'select * from ....where item_id in ('ck_names(1), ck_names(2),.....)'
I've posted this question many times but with no luck. Could someone please please help! Received on Tue Aug 03 1999 - 06:42:51 CEST
Date: Mon, 2 Aug 1999 21:42:51 -0700
Message-ID: <Pine.SOL.4.05.9908022137450.3559-100000_at_taurus.oac.uci.edu>
I'm using cookies to store the items in the shopping cart and when the user clicks on view shopping cart, I retrieve all the itmes in the shoppping cart thru owa_cookie.get_all.
All the item ID# and its quantities are stored in ck_names, and ck_vals respctively, which are both of type owa_cookie.vc_arr I want to retrive price and description of these items and can't figure out how to go about making the call to database. There two tables, one that has item price and another that has item description.
HOw can I go about using curosr to call the database once and retrive every price and description for items in shopping cart. I know waht should be done, it's just that I can't write it to work in pl/sql
For instance, since the number of items in shopping cart differ everytime, I can't use 'select * from ....where item_id in ('ck_names(1), ck_names(2),.....)'
I've posted this question many times but with no luck. Could someone please please help! Received on Tue Aug 03 1999 - 06:42:51 CEST