help! Updatable cursor

Hi,

I need to have a "writable" cursor generated and processed in a function and then return the cursor back, it's for print report purpose.

Let's see a simple example,

The basic query looks like
Select emp_name, emp_age, 0 as emp_complex_1, 0 as emp_complex_2, 0 as emp_complex_3 ..
From Employees
Where ....(the condition is a string passed in)

The columns emp_complex_1, emp_complex_2, emp_complex_3 can only be obtained through some function call, we just create the column with 0 as the initial value in above code.

So I need a function which can handle a dynamic-cursor (because the where condition is passed in from client side), and also can loop through the cursor, fill in (Update) some calculated columns and then return the cursor.

Could you give me some idea how to do this?

Really appreciate your help!!

Dana
Dana_jian_at_hotmail.com Received on Mon Apr 03 2000 - 11:21:29 CDT