Topic: ORACLE and multiple refCursors
author: phpWalter
created: 26-06-2012 00:45:16 AM
|
OK, I found the sample code to pull "2 out parameters"...
http ://phplens.com/adodb/reference.functions.executecursor.html
But this only works with 2; I have several Oracle Procedures that have 3 or more returned REF CURSORS, not just primitives (as this sample shows)
Anyone have any idea on this?
I'm in week 3 of trying to figure this out. I can do it native PHP but not in ADOdb.
Thx |
|
Topic: Re:ORACLE and multiple refCursors
author: John Lim
created: 26-06-2012 03:55:47 AM
|
Hi Walter,
REF Cursors are unique to Oracle so ExecuteCursor() was a simple way of handling 1 REF CURSOR.
Given that you have several Oracle Procedures that have 3 or more returned REF CURSORS, i don't think this part can be coded in ADOdb, as the portability layer breaks down with something so Oracle specific.
Sorry. John |
|
Topic: Re:ORACLE and multiple refCursors
author: phpWalter
created: 26-06-2012 03:37:55 PM
|
Thanks for he reply.
I'm sorry to hear that. Would someone please update the docs to reflect this fact so the next guy does do what I did?
http ://phplens.com/adodb/reference.functions.executecursor.html
"ExecuteCursor only accepts 1 out parameter. So if you have 2 out parameters, use:"
"Please note: Current adoDB does not allow more than 1 REF CURSOR returned form an Oracle Procedure, but it does allow multiple 'primitive' values to be returned."
Does anyone know the real inner workings and would mind lending a hand to create a "MulipleCursor" method? This has become a "deal killer" for our project and I don't want to lose this excellent tool.
Walter |
|
|
