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

$action = "insert"; //$action = $_GET['action'];
$action = "insert";
//$action = $_GET['action'];

why is this invalid type? I am

php forms and database navigatio
Hello,
I'm new to php and i'd like to post the following.
I have written code to get records f

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?
<

Passing JS to PHP
So I have the following
Code: <?php
getdetails(?><script type="text/

php wont update my db
hello,

sorry for posting in mysql forum but i dont know where exactly is the problem but here

Database 'Validation'
Hi everyone,
I'm trying to validate the password entered by the user with the password in the dat

Limiting uploaded file type
Hi. First post here
I am working on a simple upload script, and I need it to limit the allowed f

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

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

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