Recent content by TyzA

The NextRecordset did it. Thanks all for your help. -T

Thanks but I already tried this. It works for .NET but not for VBA. Is it actually possible to retrieve multiple Oracle ref cursors with VBA? -T

And which datatype should these parameters have? In Oracle they are of the type Refcursor I've tried several but I always get an error that there is a mismatch in datatype -T

Hello, I have this MS access application which needs to retrieve multiple refcursors from an Oracle database and export this to a MS Excel workbook. Per refcursor a sheet needs to be used to place the contents of the refcursor. What I have so far is that I can retrieve the first refcursor...

Thanks guys. I'll look into the cron jobs I was thinking in that direction as well.

Hi, Is it possible to create a sequence which will reset itself at the start of each month? Thanks, Tijs

Hi, Is the following possible: select * from table_x where field_x in (value_x, value_y, value_z) value_y doesn't exist in the table thus logically speaking the query would only return the results for value_x and value_z. Now my questions is, can I also retrieve a blank row for value_y via...

One more question: Is it possible to provide input parameters to the function/stored procedure in question? if yes, how does it work? as follows? select * from table(get_tab(param1, param2))

Thanks Dagon. I think this is what I'm looking for. I'll give it a try. So with create or replace TYPE TMP_REC IS OBJECT (DUMMY_ID INTEGER) I can basically define a complete structure like? create or replace TYPE TMP_REC IS OBJECT (DUMMY_ID INTEGER, name varchar2(25), street...

Hi, Is it possible to create a view based on the output of a stored procedure? this output will be a recordset This stored procedure will access a few tables, do some transformations on the data and this data should then be returned to Business Objects. Since Business Objects doesn't support...

You're correct jpadie. There must have been something in front of my first line. I've copied the code into a new file and it worked. Tx

For some reason I just keep on getting this error: Warning: Cannot modify header information - headers already sent by (output started at C:\devtools\xampp\htdocs\pp\xlsreport.php:1) in C:\devtools\xampp\htdocs\pp\xlsreport.php on line 3 This is the piece of code causing this: line 1:<?php...

OK This problem is solved. There was no permission to access the directories. But now I get a different error. I still use the same code as I was before (and which was working) but now I get following error: DB Error: not found Here is my code how I create my connection: <?php...

They told me they checked the permissions. So I guess this should be alright

Hi, My website was runing fine for a few months but no all of a sudden i get following error while accessing my database: Warning: main(DB.php): failed to open stream: No such file or directory in /home/w20998/public_html/test.php on line 5 Fatal error: main(): Failed opening required 'DB.php'...