Can i execute query and sql function in same statement?

Question

I have a PreparedStatement and CallableStatement:

String sql = "INSERT INTO parcels (cadastr,the_geom,status_id) VALUES(?,PolygonFromText(?, 4326),?)";
PreparedStatement stmt = ce.prepareStatement(sql);
stmt.setString(1, ts.getPackage().getSpecifyParcels().getExistParcel()
        .get(0).getCadastralNumber());
stmt.setString(2, WKT);
// stmt.setString(3, deleted);
stmt.setInt(3, status_id);
stmt.execute();
stmt.close();

java.sql.CallableStatement proc1 = ce
        .prepareCall("{call insert_into_wgs()}");
proc1.execute();
proc1.close();

Its possible to execute this query and function insert_into_wgs() in one statement?

Daniel · Accepted Answer · 2012-12-20 08:05:08Z

1

Use the RETURNING keyword!

INSERT INTO parcels (cadastr,the_geom,status_id) 
VALUES (?, PolygonFromText(?, 4326), ?)
RETURNING insert_into_wgs()

edited Dec 20, 2012 at 8:05

user330315

answered Dec 20, 2012 at 6:23

Daniel

28.2k20 gold badges93 silver badges140 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Kliver Max Over a year ago

Thank for answer. But unfortunately insert_into_wgs() works with results of INSERT query(

Kliver Max Over a year ago

Why you use SELECT instead VALUES?

Daniel Over a year ago

Replaced my previous answer with a real solution

Daniel Over a year ago

Because I copied it from rs.'s solution ;) His post is already deleted btw. Fixed.

Kliver Max Over a year ago

So i gonna use this: INSERT INTO parcels (cadastr,the_geom,status_id) VALUES( ?,PolygonFromText(?, 4326),? )RETURNING insert_into_wgs() ????

Collectives™ on Stack Overflow

Can i execute query and sql function in same statement?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related