this thread is a duplicate of the following:
9606542
but i'm getting no responses and the problem is not solved!
i have this object in my oracle database:
CREATE OR REPLACE
TYPE REPORT.FATTURA_OBJ AS OBJECT (
POD VARCHAR2(1000),
ID_FATTURA NUMBER,
ID_FILE NUMBER,
COERENZA_EA_F VARCHAR2(1000),
COERENZA_ER_F VARCHAR2(1000),
COERENZA_EA_M VARCHAR2(1000),
COERENZA_EF_M VARCHAR2(1000),
ANOMALIA VARCHAR2(1000),
MOTIVO_INVALIDAZIONE VARCHAR2(1000),
MATRICOLA_CONTATORE VARCHAR2(1000),
POTENZA_DISPONIBILE VARCHAR2(1000),
MEMBER PROCEDURE pulisci
);
/
i have this java procedure
INSIDE MY ORACLE DB
CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED REPORT."Manage_Excel_ASMBS" AS
import java.io.*;
import java.io.IOException;
...
import java.io.StringWriter;
public class Manage_Excel_ASMBS
{
public static void read_Excel(String inputFile,int var_Id_Caricamento, int var_Id_Distributore, String var_Distributore) throws SQLException, IOException
{
....
#sql{ INSERT INTO log_caricamenti (id_log, messaggio, distributore, data, id_caricamento) VALUES (LOG_CARICAMENTI_SEQ.nextval, 'getNumberOfSheets: ' || :riga , null, sysdate, :var_Id_Caricamento) };
...
**here i need to put what i'm reading inside the excel file into oracle objects**
}
}
/
as u can see, i have no connection 'con' to connect to the oracle db, since i'm already inside my database... so i use this statement: #sql{ INSERT
what i need is to use REPORT.FATTURA_OBJ inside my java procedure.
this is the code has been suggested me i have no connection 'con' and i don't know what to do
StructDescriptor headerStruct = StructDescriptor.createDescriptor("T_INVOICE_HEADER", con);
please help me
thanks!
Edited by: LinoPisto on 23-mag-2011 11.50