Question about cursors in a function and how to return the results

Advertisement
Hi all,
Some tech info:
I'm using Oracle 11G database and APEX 4.0.2.00.06
I use three cursors in a function. My function is called in an APEX standard report, like this by example:
SELECT fnc_exp(tab.arg1, tab,arg2) FROM table_exp tab;
My question is: how can I return the values calculated from my function to a standard APEX report? Before, this function was used like this by Oracle Forms to fetch the cursors in the right table columns:
open c_a;
fetch c_a into :loc.arg1;
close c_a;
open c_b;
fetch c_b into :loc.arg2, :loc.arg3, :loc.arg4, :loc.arg5;
close c_b;
Thanks for your advices!
Maybe my solution is not right, if you have better ideas, please suggest :)
PS: If you need more details, please ask which you need.
Advertisement

Replay

Hi,
I don't think you can do exactly like that in APEX.
Go for a pipelined function if you want the value be returned from the function.

Difference matte and how to fix the result?

I did find this "tutorial" video of how to use Difference Matte: http://www.mefeedia.com/entry/difference-matte/10818096/ But I would like to know, how I can edit the result? I did the Difference Matte and stuff, but I have a hole/transparent se

How to return the result set of multiple select statements as one result set?

Hi All, I have multiple select statements in my stored procedure that I want to return as one result set  for instance  select id from tableA union  select name from table b  but union will not work because the result sets datatypes are not identical

Here's a very basic question about 2 TB external drives and Time Machine.

Here's a very basic question about 2 TB external drives and Time Machine. Ihave a Mac Pro with a .75 TB and 1 TB drive.  It also has a 1 TB 2ndinternal drive.  My current external drive is too small so I'll begetting a 1.5 TB or 2 TB drive. Obviously

Disk utility can't repair the Macintosh HD, asking toback up all files as possible? and how to  reformat the disk?

disk utility can't repair the Macintosh HD, asking toback up all files as possible? and how to  reformat the disk?Some problems can indeed be fixed this way. But working from Recovery_HD or Disk Warrior DVDs and working in the restricted environment

TS4291 I can't send mail from my iPad apps, I just get the error message, 'The recipient- was rejected by the server because it does not allow relaying.' Does anyone know what this means and how to fix the problem.

I can't send mail from my iPad apps, I just get the error message, 'The recipient- was rejected by the server because it does not allow relaying.' Does anyone know what this means and how to fix the problem.iOS: Unable to send or receive email http:/

I just purchased a secondhand iPad in carboot and I didn't realised that the old account is still linked to the device now can't  activate my accnt.i don't know where  and how to contact the original owner.what should I do?is there any other option?

I just purchased a second hand iPad in carboot.i didn't realised that the old accnt is still linked to the device,now I icant activate my account .I don't  know where and how to contact the original owner.what should I do activate my accnt?is there a

How to start weblogic in debug mode ? and how to set the eclipse in the deb

how to start weblogic in debug mode ? and how to set the eclipse in the debugPut this in JAVA_OPTIONS : Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,address=3999,suspend=y,server=y After restarted weblogic, in eclipse set your

What file name is for the driver of gpib-usb-b?and how to add the driver file to vb in win2000??thanks

what file name is for the driver of gpib-usb-b?and how to add the driver file to vb in win2000??thanksHi, Multiple files are required for the proer fnctioning of any of our GPIB products. Unfortunatly the installation is not as simple as copying a si

The power went out and when it returned the network name and password was lost.  I can see the network in my connections and connect to it.  How do I get it back to the orginal name and password.  I have an HP laptop

The power went out and when it returned the network name and password was lost.  I can see the network in my connections and connect to it.  How do I get it back to the orginal name and password? I have an HP laptop. Chances are, there was a signfica

How do you have Google searches appear in new tab? This was previously not a problem, but it changed and I cannot return the setting. Any ideas?

How do you have Google searches appear in new tab? This was previously not a problem, but it changed and I cannot return the setting. Any ideas?I recently purchased a second hand new macbook air, although it was second hand to me the previous owner h

HT4847 How i can download my backup data? And how to manage the data on i Cloud?

How i can download my backup data? And how to manage the data on i Cloud?You can't download an iCloud backup, except to restore it to your device should you ever need to. iCloud data can be managed within the apps on your iPad.  Any changes to the da

I have 100  songs on i pod touch. But when i connect it to itunes it only showed 44 songs. What is actually happening and how to fix the problem so that all music in my iphone can be seen in my itunes

I have 100  songs on i pod touch. But when i connect it to itunes it only showed 44 songs. What is actually happening and how to fix the problem so that all music in my iphone can be seen in my ituneIf they are iTunes purchased music then go to Setti

как вернуть текущий ключ how to return the current key

подскажите как вернуть текущий ключ виндовс.так как диска востановления нет tell me how to return the current key vindovs.tak as repairing disk noHi Xolostjak, Welcome to the HP Community, I hope you enjoy your experience! To help you get the most ou

Ever since I updated my OS, the screen on my Mac will automatically become huge if I keep my mouse on the screen. I can't figure out how to return the screen to a normal size. Any help?

Ever since I updated my OS, the screen on my Mac will automatically become huge if I keep my mouse on the screen. I can't figure out how to return the screen to a normal size. Any help?Hold down the 'ctrl' key and scroll backwards on the mouse. Then

How to execute a function and return the result into a bind variable

Hi, I am trying to calculate the sum of salaries of all persons with a particular JOB_ID using a function TOTAL_INCOME(v_job_id). create or replace function total_income +(v_job_id IN varchar2)+ RETURN number IS v_total number(6); cursor get_sal is s

What is push power protector message on sony bravia theatre all about and how to get the unit to wor

i got push power protector message on my bravia home theatre. I cannot get power to turn on. Checked all wires and rebooted the system many times. No Luck! Does any one know how to fix this problem. I am a loyal sony customer for years but found out

Question about reading a sequential file and using in an array

I seem to be having some trouble reading data from a simple text file, and then calling that information to populate a text field. I think I have the reader class set up properly, but when a menu selection is made that calls for the data, I am not su

Question about  Graphics Cards for Adobe and more

Hello, for technical people I'll start by listing some relevant computer info:    Asus P9x79Pro Motherboard . Nvidia Quadro 4000 2GB . Windows 7 . Adobe CS6 I have a workstation PC and have been considering ways to improve it. I'm pretty happy with b

Question about Linksys G Wireless Router and i cant connect my iPod Touch and PSP to it.?

I just got a new Wireless router and it works fine.The model number is WRT54G2. The internet is working and I can go on my xbox live and things like that. The only problem is that my iPod touch and things and my PSP can detect the connection but are