Originally posted by: heyspo

Hi,

We have a file with headers and lines, and when we call to Oracle for integration into tables, one for headers and one for the lines, after appropriate validation, the headers are inserting well and the lines are inserting exponentially.
For example:
When we have a file with a header and lines the insertion is ok, the problem comes when there are more than one header.After the second header, inserts its lines and the lines of the before headers.

could you help us?

thanks.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: phil2030

How are you inserting into oracle? Have you two output cards? Am I correct in guessing you input tree describes the input as somethingsimilar to the following structure?

File
Doc (s)
Header
Line (s)
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: heyspo

=VALID( DBLOOKUP(
"CALL APPS.PK_ITF_1104_152.P_INSERTAR_1104_152("+PACKAGE(Transmision) 
/*           +","+"NOMBRE_FICHERO"+",?,?)","-MDQ %mdq_file% -DBNAME GREDAPR"),*/ +
","+PACKAGE(Nombre_Fichero)+
","+
"123456"+
",?,?)",
"-MDQ C:\Documents and Settings\I0834\Mis documentos\itfI.mdq -DBNAME GREDAPR -T traza_DB.log"), +LASTERRORCODE()+LASTERRORMSG() )

we call to oracle procedure with a "DBLOOKUP" and our structure is something like this:

file docs(s) head (1:1) line(0:1) lines (s)

we beleave that the problem is how oracle interprets the type
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: phil2030

So what is Transmision & Nombre_Fichero with regards to your structure? What are you doing in PL/SQL in your SP? What are the arguments to the SP?
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: phil2030

..also, is that a mistake in your structure?

file docs(s) head (1:1) line(0:1) lines (s)

why have you line(0:1) containing lines (s)? If not, does line contain anything other than lines?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: heyspo

The structure is done by the mts maker,I think it´s ok!!

Transmision is the file (structure) and Nombre_de_fichero is the name of the file.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: phil2030

...so your PL/SQL is doing something incorrect?
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender