Procedure with variable number of columns

Posted on 16th Feb 2014 07:03 pm by admin

Hi, I have a procedure that looks like this:

PROCEDURE PROC(p_cursor OUT sys_refcursor)

And in the procedure, I build up QUERY dynamically and the number of columns varies at runtime.

At the end I do

OPEN p_cursor for QUERY
Then to call this, I'm doing

call PROC(?)

My question is, how would I go about running the query from this procedure, then adding rows or modifying the existing results, then returning the modified data?

What I want to do is add a new row based on some condition, so I still need to return a variable number of columns, but I need to modify the results before I return them.

Is there any way of doing this? I need to do some calculations on the columns (the variable columns), create a new row, insert into result set, and return this new result set.

Your Answer:

Login to answer

Other forums

Calender Not Opening
The following code is not loading the javascript calender in another window. It's not doing anything

Is this possible? If one file assigned to an ID...
I have a page that lists property listings assigned to a specific user (a manage page), with brief t

Transferring session variables into MySQL
I am trying to transfer $_SESSION variables into MySQL. However there is an error in my MySQL statem

single values into sql field
i have a form which i want the user to able to select multiple answers. But i want the answers to be

Perplexing problem showing a .jpg
Please disregard..........I figured it out

help finding hacking loopholes
i was attacked by a redirect php injection

my pc is clean of viruses

so i figure that

Business Health Check
Hello

I need to create an online business health check for a client it will be multiple choi

How to restrict the display of report variants
Hello All,

I want t know how to restrict the display of report variants.
I mean, whe

PHP, Arrays & A Lot Of Confusion
I've been doing basic PHP work on sites for a few years now, but I've never been tempted to learn ho

PHP referral database. I would like this form to email the referrer.
Okay, Hello I've been trolling for years. This the first time I've ever asked for php help. Normally