Database Tuning (MOSC)

MOSC Banner

Current Gets in Insert

edited Aug 3, 2011 11:49AM in Database Tuning (MOSC) 6 commentsAnswered
 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_

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center