: Forums

home • products examples manual • faq support forum • contact news • login store

You can enter the following UBB tags: [b]bold[/b], [i]italic[/i], [red]red[/red] and [pre] [/pre]

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

View Source

email: contact#phplens.com (change # to @) telephone (malaysia): 60-3-7947 2888 fax (malaysia): 60-3-7947 2800