Calling stored functions in executeBatch
От | Guy Rouillier |
---|---|
Тема | Calling stored functions in executeBatch |
Дата | |
Msg-id | 20050311192134.6aad0052@emach обсуждение исходный текст |
Ответы |
Re: Calling stored functions in executeBatch
|
Список | pgsql-jdbc |
I've browsed the archives and understand that I am not supposed to submit SELECT statements in batch. I'm converting some code from Oracle that invokes stored procedures via batch (for high volume inserts.) I've got the stored proc converted, but invoking in batch using "select my_proc(x,y,z)" produces the predictable "result not expected", even though my stored proc returns VOID. Is there any way I can absorb the return value from the select to prevent this error? I'd like to avoid rewriting this code as I want it to continue to run with Oracle until I successfully sell the conversion idea. I'm able to do this so far by changing the SQL statements to be INVOKE + "my_proc(x,y,z)" and then just setting INVOKE to either "call" or "select" for Oracle and PostgreSQL, respectively. Will I run into the same problem if I change these SQL statements to use the call escape format? Thanks. -- Guy Rouillier
В списке pgsql-jdbc по дате отправления: