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 184.108.40.206.
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)
INSERT INTO TUSUARIOS VALUES(usuario,descrip,cont1rep,cont2rep,cont1repa,cont2repa);
when others then
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.