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

what business processes?
Hi,

A general question. What business processes (like OTC - Order to Cach, P2P, R2R etc)

Any decent php formatter/beautifier/pretty printer?
Any decent php formatter/beautifier/pretty printer class/function?

I found the following whil

NOOB needs help with upload file
The intent of this form is to create a folder for a client and upload an image into another folder '

Hardcopy printing is to wide
I want to make a hardcopy at runtime of my active form like this

How to secure my login data to my database?
Hi there,

It may be a stupid question but I don't know how to secure my login data to my data

how can i display php source code snippets ?
I am outputting some pho code .. and I want to display the source code so people can copy and paste

using variables in another page
I have a test database set up on localhost. I have a form that I can type a name into, hit the butto

FlashVar function how to insert variables
Hi guys. Im new in this forum and also new in php programming. Can you help me about this code?
<

Simple AND question
Hello,

I've got following code:

Code: if(strpos($row[13],"http://")

error reporting
hey everyone

I have a production server in which I want error reporting but only on some page