[ psqlodbc-Bugs-1000627 ] can't use stored functions

Bugs item #1000627, was opened at 2006-05-03 08:43
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000627&group_id=1000125

Category: Interface (example)
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: can't use stored functions

Initial Comment:
I tried to use psqlODBC driver from java jdbc:odbc bridge in the way to improve efficiency
store procedure call doesn't work :
"
...
proc = conn.prepareCall("{ ? = call ps_get_lov(?) }");
proc.registerOutParameter(1, Types.OTHER);
proc.setString(2,categorie);
proc.execute();
...
"
then the following error occured :
parse tree:GetData to Procedure return failed.

this way work with JDBC driver and doesn't work with ODBC driver

----------------------------------------------------------------------

Comment By: Titus Barik (barik)
Date: 2007-01-12 03:12

Message:
conn=00DF3EA8, query='select proname, proretset, prorettype, pronargs, proargtypes, nspname, p.oid, atttypid, attname, proargnames, proargmodes, proallargtypes from ((pg_catalog.pg_namespace n inner join pg_catalog.pg_proc p on p.pronamespace = n.oid) inner join pg_type t on t.oid = p.prorettype) left outer join pg_attribute a on a.attrelid = t.typrelid and attnum > 0 and not attisdropped where has_function_privilege(p.oid, 'EXECUTE') and proname like 'phsename' order by nspname, proname, p.oid, attnum'
[ fetched 1 rows ]
conn=00DF3EA8, query='SELECT * FROM phsename(E'Reference Recipe A',0)'
[ fetched 1 rows ]
STATEMENT ERROR: func=PGAPI_GetData, desc='', errnum=13, errmsg='Invalid column number.'
------------------------------------------------------------
hdbc=00DF3EA8, stmt=00DF8A00, result=013B3F40
prepare=0, internal=0
bindings=00DFC140, bindings_allocated=1
parameters=013B3FF0, parameters_allocated=2
statement_type=9, statement='{call phsename(?,?)}'
stmt_with_params='SELECT * FROM phsename(E'Reference Recipe A',0)'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=0, current_col=0, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name='SQL_CUR00DF8A00'
----------------QResult Info -------------------------------
fields=013B3C70, backend_tuples=00DF8C98, tupleField=14650520, conn=00DF3EA8
fetch_count=0, num_total_rows=1, num_fields=1, cursor='(NULL)'
message='(NULL)', command='SELECT', notice='(NULL)'
status=100, inTuples=0
CONN ERROR: func=PGAPI_GetData, desc='', errnum=216, errmsg='Couldn't set unsupported connect attribute 1'
------------------------------------------------------------
henv=00DF3E78, conn=00DF3EA8, status=1, num_stmts=16
sock=00DF2138, stmts=00DF2200, lobj_type=-999
---------------- Socket Info -------------------------------
socket=500, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=14641648, buffer_out=14645752
buffer_filled_in=67, buffer_filled_out=0, buffer_read_in=67
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='GetData to Procedure return failed.'
------------------------------------------------------------
hdbc=00DF3EA8, stmt=00DF8A00, result=013B3F40
prepare=0, internal=0
bindings=00DFC140, bindings_allocated=1
parameters=013B3FF0, parameters_allocated=2
statement_type=9, statement='{call phsename(?,?)}'
stmt_with_params='SELECT * FROM phsename(E'Reference Recipe A',0)'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=0, current_col=0, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name='SQL_CUR00DF8A00'
----------------QResult Info -------------------------------
fields=013B3C70, backend_tuples=00DF8C98, tupleField=14650520, conn=00DF3EA8
fetch_count=0, num_total_rows=1, num_fields=1, cursor='(NULL)'
message='(NULL)', command='SELECT', notice='(NULL)'
status=100, inTuples=0

----------------------------------------------------------------------

Comment By: Ludek Finstrle (luf)
Date: 2006-06-01 18:50

Message:
Please could you attach or send to me the mylog output?
BTW minimalistic app which shows the problem is welcome.

Regards,

Luf

----------------------------------------------------------------------

Comment By: Nobody (None)
Date: 2006-05-03 15:43

Message:
I have tried with the latest release 8.01.02 (both Ansi or Unicode) and the last build 8.02.00.02

----------------------------------------------------------------------

Comment By: Ludek Finstrle (luf)
Date: 2006-05-03 12:41

Message:
What version of psqlodbc do you use?

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000627&group_id=1000125