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

Problem with shopcart code
Hello, I am having a bit of trouble being able to add a product to my shopcart. My mysql database i

TemplatePower & AJAX
Hi all,



I'm currently implementing some AJAX features in my PHP-framework (which is b

date("now") prints out wrong date ?
Hi Guys
Anyone know why and how I can fix it ?

Compare user input to flat file data
Help...Am a complete newbie to programming so my code is prolly quite long. Am trying to verify a us

Word Trimming
Hi Guys & Gals!!

Hope you are all ok....

I need some help with the following

a function to check directory depth
I'm working on a php script to upload files in to a set directory.
the user can select to upload

Online Event Ticket Sales
Has anyone wrote a script for online tickets sales?

I have been googling and found lots of th

Motivational Posters
Hello,

I wonder how can i do them in php. Are there any sample codes that you can show me?

array_map() probably obvious mistake
The code below is part of a class to escape strings, but should also accept an array, using array_ma

how to export excel file in same server
My first post - php newbie, so appreciate your support.

I'm currently using headers to save w