Func odbc show only first column of query

Hi,
I’ve configured a connection to an oracle server to read some data in a dialplan. The connection is ok, in isql I can see all data I need, but in asterisk, it shows only the first column of the select.
For example:
isql: “select * from table1” produce value1, value2, …, valuen
asterisk: “select * from table1” produce only value1!

Please help me!

You may find success with explicit column names assigned to an array, instead of the wildcard. See for example this portion of the sample features.conf:

Set(ARRAY(CDR(mark),CDR(name))=${ODBC_FOO(${CALLERID(num)})})

Do you have mode set to multirow in func_odbc.conf?
Go through the part ‘Multirow Functionality with func_odbc’ on asteriskdocs.org/en/3rd_Edit … funky.html for more information.

–Satish Barot