Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Multi-query Birt Error
Migrateduser
<p>Hi everyone! I'm new here in the community and don't know if this is the exactly forum to create this topic, so if isn't the place, plase move to the right place please, moderator.</p><p> </p><p>So, this is the error:</p><p> </p><p><span>+ </span>Cannot execute the statement.
SQL statement does not return a ResultSet object.
SQL error #1: ERROR: cannot open multi-query plan as cursor</p><p> </p><p>So, here is the thing:
Im the PL function, i'm using a ROWTYPE return, and the function creates 2 FOR iterations to bring some registers from the database to assign to the rowtype variable, and return it.</p><p> </p><p>I've tried to change this to return a record, but it didn't work. Whenever I remove the 2 FOR iterations, the function returns the rowtype (I set some fixed parameters in the rowtype to do this) and don't have errors. But everytime I put the FOR iterations, it brings again the errors.</p><p> </p><p>The function don't returns anything in these 2 FOR iterations.
sorry for the bad english, english is not my formal language.</p><p> </p>
Find more posts tagged with
Comments
There are no comments yet