(older archive entries before 2007 are not shown here, but included in the onsite-search)
Mailing List - Entries of 2014
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [QF-Test] Procedure "executeSelectStatement" with sample Select Query returning error getting index , type [-9] [SQLCode: 0]
I think I've figured it out.
It might be a casting issue
select cast( COUNTRY_NAME as varchar(64)) from MySchema.country
Le Vendredi 28 février 2014 17h03, Gwenael Plantefeve <gwen0504@?.com> a écrit :
I am trying to call the "qfs.database.executeSelectStatement" procedure to query an Oracle Database.
Here are the following input parameters:
statement select COUNTRY_NAME from MySchema.country
Within "Plugin" folder I put the following Oracle Driver jar: ojdbc6_g.jar
I keep getting the following error message:
The following error was encountered:
Exception during executing statement : error getting index , type [-9] [SQLCode: 0]
When debuging Jython code of "qfs.database.executeSelectStatement", I can see the connection is fine and the error occurs at the following line:
Note if I modify the query to count(*) (eg select count(*) from MySchema.country)
It works fine.
So I can't figure out why sample query such as "select COUNTRY_NAME from MySchema.country" is not working as well?
Thanks in advance for your help on this issue