Обсуждение: Callable statements
Hi, could anyone tell me about the callable statements and how they work on postgres? im migrating a db from sql server 2000 to postgres and in some programs this type of statements is used for executing stored procedures (but in postgres there are none right? there are functions...) Help here, i'm confused... thanks JuanF
Juan: The functions are stored procedures. So, you use CallableStatement to call the postgres functions... Scot -------Original Message------- From: Juan F Diaz <j-diaz@publicar.com> Sent: 08/21/03 11:06 AM To: pgsql-jdbc@postgresql.org Subject: [JDBC] Callable statements > > Hi, could anyone tell me about the callable statements and how they work on postgres? im migrating a db from sql server 2000 to postgres and in some programs this type of statements is used for executing stored procedures (but in postgres there are none right? there are functions...) Help here, i'm confused... thanks JuanF ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
Juan, There are now examples of using callable statements in the postgresql jdbc documentation. Check out: http://developer.postgresql.org/docs/postgres/jdbc.html thanks, --Barry Juan F Diaz wrote: > Hi, could anyone tell me about the callable statements and how they work > on postgres? im migrating a db from sql server 2000 to postgres and in > some programs this type of statements is used for executing stored > procedures (but in postgres there are none right? there are functions...) > Help here, i'm confused... > > thanks > > JuanF > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
Barry Lind <blind@xythos.com> writes: > Juan, > > There are now examples of using callable statements in the postgresql > jdbc documentation. Check out: > http://developer.postgresql.org/docs/postgres/jdbc.html I wrote an article for onjava about this: http://www.onjava.com/pub/a/onjava/2003/08/13/stored_procedures.html?page=1 Nic