Can someone help me?

I have a package with a procedure like that:

PACKAGE test_pkg IS

TYPE rc_assuntos IS REF CURSOR

PROCEDURE GETALL(result IN OUT rc_assuntos);

END;

PACKAGE BODY TEST_PKG IS

PROCEDURE GETALL(result IN OUT rc_assuntos) IS
BEGIN
OPEN result FOR SELECT tema_primario FROM ASSUNTOS;
END

END;

As you can see this procedure has as input/output variable type a REF CURSOR.

I have created a ZSP to use the function above:

ZSP description:

procedure TEST_PKG.GETALL has arguments:
	RESULT IN OUT REF CURSOR

I cold not test it because it asked for a cursor as input.

So... I tried to use an Python Script like that to pass and receive a cursor for this ZSP:

"""
teste

NO PARAMETERS LIST.
"""

db= context.Oracle_database_connection   #    use my current Oracle conection. Is it correct?
c= db.cursor()                                           #    create a cursor object
dbsproc = context.ZOSP2(c)                      #    call mu ZSP and pass the cursor object
rs=c.fetchall()                                           #    get the result set and use it
print rs

When I run this Script I have the folloing error:

Error Type: AttributeError
Error Value: cursor

So what is wrong?

What can I do to receive a REF CURSOR type from a ZSP from ZOPE?

Or getting a REF CURSOR type from an Oracle procedure using ZOPE?

Is there an easier way?

Can I use External Method? If I can, how do I do it?

Many thanks.

Ricardo