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

How to find OS bit version
How can I tell the person browsing my site is running 32, or 64 bit operating system?

background color imagefill
Hello

I would like to ask you why I see this square in red color just in my local xampp insta

returning data from an ssh2_exec()
here's what i got.


$conn = ssh2_connect($this->_host);
ssh2_auth_password($c

frames get header location..
i have two frames, one top, one bottom. how do i do a form on the bottom frame that gives me the ur

problems with contact forms that are only protected against SQL injections
What could be a potential problem with contact forms that are only protected against SQL injections

Need help to modify php ELSE code
I'm trying to find a way to have the php code display a message if there is no inventory listed in t

modifying query string with no page refresh
Hi everybody,
I've tried to get info about my problem all over the internet but i didn't find out

Update not working ... please help
Hi,

I am trying to update a row using an edit form by passing id of the row .. but it is not

Error: SQL Syntax; Line 1
Code:

<?php require "global_settings.php"; ?>
<title&g

Ajax not working on IE 6 for Windows CE
I've created a webpage which uses the classis Ajax in following format:view plaincopy to clipboardpr