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
participants (1)
-
ricardo@cnbe.mar.org.uk