Recover cursor from PL/SQL Oracle

Classic Servoy
1

Hello.

I’m trying to recover values from a stored procedure in a Oracle PLSQL function to use it in Servoy into a dataset object.

The problem is that Servoy don’t recognize the cursor type from Oracle.

Anybody knows how what can I do to solve this problem?

if not posible, how can I recover cast array type from cursor type in a Oracle PLSQL function?

Best regards. Roberto Blasco.

2

Can you paste the SQL code that you use to call the function from a SQL console?

3

Hello ngervasi

This is how i would write it

select pkg_mypackage.f_myfunction(parameters) from dual;

This one returns a ref_cursor type.

We already test it inside a getDataSetbyQuery statemet (with rawSQL too) and the results are always the same (null or error), just becase Servoy don’t understand Oracle types.

Best regards. Roberto.

4

Did you alto try to use executeStoredProcedure? What kind of params is that function expecting and what kind is returning back?

5

Hello ngervasi.

I’ve already tryed with executeStoredProcedure and I’ve got always an error like response.

The store procedure expects a varchar2 and returns a ref_cursor (oracle cursor type). The problems is that servoy don’t recognize this kind of types, only the java standard ones.

Maybe I can fix this problem trying to use the features of Servoy with import Packages, using the native class for oracle?

Un saludo. Roberto.

6

That would work for developer but not for smart client (unless you build a plugin), I guess that the best option is to create a case in the support system.

7

Hi ngervasi.

Thanks a lot. I’ll do it.