Re: Creating PROCEDURE from python
Zsolt Kendi Wrote:
-------------------------------------------------------
> And only if the procedure return any selectable
> result. Otherwise working fine.
Victory!
The procedure return result set for each SELECT. This mean if you have
SELECT ... INTO @aaa
SELECT @aaa
then return two result set.
If after the callproc() just one fetchall() executed then one result set stay in return stack. If this result set not fetched with nextset() and fetchall() then you get error on every next execute!
Subject
Written By
Posted
Re: Creating PROCEDURE from python
March 20, 2009 03:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.