[ 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