Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: What's wrong in my code, Any idea
"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message news:MPG.197f67cac5a5e7e79897f1_at_news.la.sbcglobal.net...
--snip--
> CREATE OR REPLACE PROCEDURE TestCountSum (
> p_organ_tx varchar2,
> p_temp_name varchar2,
> p_category_tx varchar2
> ) IS
> --
> cursor c_category is
> select some_cat_col
> from category
> where category_tx = p_category_tx;
> --
> cursor c_second_table (
> p_some_param varchar2
> ) is
> select some_num_col, some_text_col
> from sum_demo_surg_block
> where some_other_column = p_some_param;
> --
> v_organ_tx number;
> v_value_tx varchar2(32);
> BEGIN
> --
> -- for each category record...
> for r_category in c_category loop
> --
> -- read corresponding row in second_table
> for r_second_table in c_second_table (
> r_category.some_cat_col
> ) loop
> --
> -- calculate some stuff
> v_organ_tx := r_second_table.some_num_col * 10;
> v_value_tx := r_second_table.some_text_col
> || to_char(v_organ_tx);
> --
> -- insert calc'd values in table.
> insert into sum_disc_tx (
> organ_tx
> , sum_id
> , datestamp
> , value_tx
> )
> values (
> v_organ_tx
> , seq_sum_id.nextval
> , sysdate
> , v_value_tx
> );
> end loop;
> end loop;
> END TestCountSum;
>
Karsten,
But you are using binds .. aren't you? Maybe I'm missing something obvious
Anurag Received on Wed Jul 16 2003 - 18:01:45 CDT