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

Forums: phplens   adodb
Forum:   PHPLens Technical Support
author's name*
email*
topic*
body*
To help us reduce spam, please enter the text in the picture above

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