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

Formatting echo from database
So I have a database that stores First and last names, then echos them back to a website, as of now

Two warning messages
Quote<b>Warning</b>: mysql_real_escape_string() expects parameter 1 to

Best PHP Documentation generator
Hello guys!

I would like to hear from you what is the best PHP documentation generator. Perso

Request.UrlReferrer
I need to make it so that a page can only be loaded when a button is clicked on a specific page. I d

Check Date/Time in PHP
What I need the code to check is that $reQuest is 24 hours in the past then return a time based on h

need help in update query
i create a form for update. there are 8 columns in my mysql table. on my main page all the data is r

Need help: how to catch acess of undefined class properties
Hello. I am learning OO with PHP and have hit a problem.
Some code runs as perfectly valid code,

Greek characters in php
Hi,

I'm making a script and I m using for first time greek characters.
I started to write

Email with Attachments in PHP
Hi Friends

How to send email in PHP with attachment.
I know simple mail can be sent with

str_replace help
Hey there,

I'm a PHP newb, I'm having troubles with the str_replace function. I want to clean