Skip to Content
0
Former Member
Sep 12, 2007 at 04:53 PM

Use function procedure for JDBC conector

10 Views

Hi to all,

I have a problem with procedure functions with JDBC connector in Visual Composer.

I'm using SAP Netweaver 7.0 SP12 and the external database is Oracle 9.2.0.7.

I have created a system type JDBC connector in the Portal.

I have the following funtion defined in the database to insert a record into a table:

<i>CREATE OR REPLACE FUNCTION Vc_Addrec_Tusuarios

(usuario IN TUSUARIOS.USUARIO%TYPE,

descrip IN TUSUARIOS.DESCRIP%TYPE,

cont1rep IN TUSUARIOS.CONT1REP%TYPE,

cont2rep IN TUSUARIOS.CONT2REP%TYPE,

cont1repa IN TUSUARIOS.CONT1REPA%TYPE,

cont2repa IN TUSUARIOS.CONT2REPA%TYPE)

Return integer

AS

BEGIN

INSERT INTO TUSUARIOS VALUES(usuario,descrip,cont1rep,cont2rep,cont1repa,cont2repa);

RETURN 0;

Exception

when others then

RETURN 1;

END vc_Addrec_Tusuarios;</i>

When i use this function with visual composer, the record is inserted correctly, but i have problems with the return value.

In the log appears: <i>"38: [AAD4I] Number of rows in OUTPUT is: undefined"</i>

I also tried to use a system type BI UDI JDBC and execute a sql sentence type "insert into TUSUARIOS values ('ss','ss','ss','ss','ss','ss')" and with the SQL editor, but never worked it.

Anyone could help me?

I need know if it's possible to insert, delete and update records in an external database, and how.

Thanks very much.

Best regards,

Fernando.<i></i>