/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package javaoracle;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Types;
import oracle.jdbc.OracleTypes;

/**
 *
 * @author stg_cisse8417
 */
public class ConnexionIsotest {

    public static void main(String[] args) throws SQLException {
    
        try {
            Class.forName ("oracle.jdbc.OracleDriver");
       
            Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@10.100.235.13:1590:ISOTEST", "Apps", "******");

                Statement stmt = conn.createStatement();
                
                 //create callableStatement obj
                CallableStatement appel = conn.prepareCall("{call apps.XXNES_FACTURE_IMMEDIATE_PKG.create_invoices_prc(?, ?) }");
 
						appel.setString(1,"test");
						appel.setInt(2,101048);
						//appel.registerOutParameter(2, OracleTypes.VARCHAR);

                                                appel.executeQuery();
                                                
                                                

            System.out.println("connexion bien établie");
        }catch (ClassNotFoundException e){
            System.out.println("Erreur connexion");
        }

    }
    
}