Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*
- def host = '10.225.24.67'
- def port = '1643'
- def sname = 'BDKAOS.DOMDESA'
- 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=$sname)))", 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()
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement