import java.sql.*

def host = '10.225.24.67'
def port = '1643'
def user = 'golf'
def pwd = 'ladesiempre'

def conn = DriverManager.getConnection("jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=$host)(Port=$port))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=BDKAOS.DOMDESA)))", user, pwd)
try {
    def cs = conn.prepareCall( '{call PQPDU.CONTABLAPDU(?,?,?,?) }' )
    try {
        cs.setObject( 1, 'TABCUNICO', Types.VARCHAR )
        cs.setObject( 2, 'CUNICOCONF', Types.VARCHAR )
        cs.registerOutParameter( 3, Types.INTEGER )
        cs.registerOutParameter( 4, -10 )
        cs.execute()

        def sb = new StringBuilder()
        sb.append( '3 nrec: ' ).append( cs.getObject( 3 ) ).append( '\n')

        def rs = cs.getObject( 4 )
        try {
            sb.append( '4 crsr: ' )
            while( rs.next() ) {
                sb.append( rs.getString( 1 ) ).append( ' ' )
            }

        } finally {
            rs.close()
        }

        return sb

    } finally {
        cs.close()
    }

} finally {
    conn.close()
}