execute a oracle function from power house

[Joaquin Malato]

Hi all,

 

    We have problems when try call an Oracle stored procedure from power
house

 

    This is the example,

 

    We have this procedure

CREATE OR REPLACE PROCEDURE <USER_SCHEMA>.RESERVAS( TCLAVE_MAT_EMP IN
VARCHAR2, STOCK OUT NUMBER) 

AS

    

BEGIN

     SELECT CANT_FLOT_STOCK INTO STOCK FROM ALMACEN_GENERAL

                   WHERE CLAVE_MAT_EMP = TCLAVE_MAT_EMP;    

 RETURN STOCK;

END;

/

 

 

This is the power house code

 

screen aa

 

TEMP TCLAVE_MAT_EMP varchar * 42 INITIAL "026   11101
000010200720080000200000000015"

TEMP TCANTIDAD num * 11

 

SQL IN SGTOMPLA DECLARE CSR_CURSOR CURSOR FOR &

CALL TRESERVAS(TCLAVE_MAT_EMP IN, TCANTIDAD OUT)

 

cursor csr_cursor primary

 access sequential

 

field tcantidad display 

 

build

 

when we run the procedure from SQLPLUS it works well and return a
correct value. But when we execute the above powerhouse code we can't
get values. This is 

the messege that powerhouse return

 

No records were found matching index/selection values. 

 

 

Thanks to all

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20080613/edda1cc7/attachment-0002.htm