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.
writing a screen scraper
Hello,I'm writing a screen scraper application and want to be able to get absolute addresses for images from relative links.So a link like this: Code: <img
php redirecting
i wont open a new thread but i have a question about redirecting....i wonder why my code doesnt redirect me..........foreach ($_POST as $key => $value){if ($req == '1'){if ($value ==
Help With editting and deleting form
Hallo !!So look at this image :http://img194.imageshack.us/img194/8272/snapshot5f.png This table prints the titles of entries from a table in a database.. The code that i use for this table is this
Multiple includes losing variables
Hey all,just starting out w php and ran into a problem pretty quickly. I'mincluding several files into each page. The variables in the first include file are functional in the main page, but are
question about header() security
is is safe to just use the header() function to redirect someone if they are, say, not logged in? or should i always put a die() function underneath the header() function?
I got my hosting suspended XD
So I saw this challenge a day or so agohttp://www.programming-challenges.com/pg.php?page=downloadproblem&probid=110101&format=htmlAnd I thought to myself "Well, what about numbers
getting rid of quotes in strings
sick of trying to deal with them in multiple ways (entering in and taking from database, echoing, echoing within a text input, etc) so i would just like to get rid of them.turn: bob's houseinto: bobs
I am stumped
OK. Here is what I am trying to do. I have the conditions set, and if the conditions are met, I want to randomly find a user id, and username from a table, and then store each of these names in the
that old Malformed Headers problem again!!!!! HELP!!!!!!
I've read the http://www.phpfreaks.com/forums/index.php/topic,37442.0.htmlI don't think my code outputs any blank lines (I can't find it anyway)I am including a functions file in my project all over
Data storage spaces in varchar2
Trying to understand what's happening.
