Current Gets in Insert
Hi,
I have the following problem :
output tkprof :
--------------------
INSERT INTO CASTES
SELECT REGCUA_SEC.NEXTVAL REGCIN_CODIGO___,
:strVarBi1_t REGCIN_REGTRE_CODIGO___,
:strVarBi2_t REGCIN_REGCUA_CODIGO___,
853 REGCIN_PROCES_CODIGO___,
1 REGCIN_SECUENCIA,
5 REGCIN_TIPOREGIS,
351 REGCIN_CODIFORMA,
SALIDA.*,
USER REGCIN_AUTOCREA_,
SYSDATE REGCIN_FECHORCRE,
USER REGCIN_AUTULTMOD,
SYSDATE REGCIN_FEHOULMO_
FROM ( SELECT :strVarBi3_t REGCIN_CODICOLUM,
F_CompletarCampo(F6SBC__UNIDCAPTU, 2, 3, 0, 'N' ) REGCIN_CODIUCAPT,
F6SBC__SUBCUENTA SUBCUENTA,
F_RecuperarSigno(F6SBC__FECHCOMP_ ) REGCIN_SIGNO____,
F_CompletarCampo(F6SBC__FECHCOMP_, :strVarBi6_t, :strVarBi7_t, :strVarBi8_t, :strVarBi9_t) REGCIN_VALOR____,
'15/03/2011 00:00:00',
F_CompletarCampo(00, 2, 3, 0, 'N' ) REGCIN_TIPOINFOR
FROM F6SBC_
I have the following problem :
output tkprof :
--------------------
INSERT INTO CASTES
SELECT REGCUA_SEC.NEXTVAL REGCIN_CODIGO___,
:strVarBi1_t REGCIN_REGTRE_CODIGO___,
:strVarBi2_t REGCIN_REGCUA_CODIGO___,
853 REGCIN_PROCES_CODIGO___,
1 REGCIN_SECUENCIA,
5 REGCIN_TIPOREGIS,
351 REGCIN_CODIFORMA,
SALIDA.*,
USER REGCIN_AUTOCREA_,
SYSDATE REGCIN_FECHORCRE,
USER REGCIN_AUTULTMOD,
SYSDATE REGCIN_FEHOULMO_
FROM ( SELECT :strVarBi3_t REGCIN_CODICOLUM,
F_CompletarCampo(F6SBC__UNIDCAPTU, 2, 3, 0, 'N' ) REGCIN_CODIUCAPT,
F6SBC__SUBCUENTA SUBCUENTA,
F_RecuperarSigno(F6SBC__FECHCOMP_ ) REGCIN_SIGNO____,
F_CompletarCampo(F6SBC__FECHCOMP_, :strVarBi6_t, :strVarBi7_t, :strVarBi8_t, :strVarBi9_t) REGCIN_VALOR____,
'15/03/2011 00:00:00',
F_CompletarCampo(00, 2, 3, 0, 'N' ) REGCIN_TIPOINFOR
FROM F6SBC_
0