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
Hi Areon Ku, thanks for writing this:
> My code may not be complete... Its just a sample --Actually What i,m trying
> to achieve here is to pick one of the value from category table and use that
> value to calculate distinct values from another table and do some
> calcualions on that and insert these calculated values into another summary
> table and repeat the same thing for next value in the category table..
> The problem i,m facing is i,m not able to use that variable as input to
> cursor and then process other statements based on that variable.
> Hope i,m able to explain the situation here.
>
> Thanks
> !!
If I understand you correctly, why not try something like this (I probably haven't even come close to the table and column names you'll need):
CREATE OR REPLACE PROCEDURE TestCountSum (
p_organ_tx varchar2, p_temp_name varchar2, p_category_tx varchar2
Just don't let Tom Kyte (see http://asktom.oracle.com) see this because he'll have a stroke since I'm not using bind variables ... but it's just an example to show the general layout.
-- [:%s/Karsten Farrell/Oracle DBA/g]Received on Wed Jul 16 2003 - 16:47:28 CDT
![]() |
![]() |