I'm not sure, but could it be that in
SELECT * FROM table name WHERE PRTY_ID=#partyId# AND STATUS='A'
AND LIST_TYPE='BUSINESS' AND UPPER(name) LIKE UPPER('%'||#buName#||'%')
the property buName is not being properly joined with the string '%' ?
I usually change the property v
Can you modify "name" to include %, instead of using it in the query?
#name# --> "%" + name + "%"
2009/9/23 HelpMePlz :
>
> Hi to all,
>
> select * from Someone where name like 'a%'
> this is in oracel
>
> if i run this query i am getting only 3 records
>
> for this query in ibatis
>
> Select
Hi
Since you're only updating a parameter, I think you should use the update
method for the sqlmap client:
sqlMap.update("getAccountEmailViaProcedure", param);
And then get the updated parameter from the parameter map itself:
String email = (String) param.get("email");
And the parameter "id" s
Hi
This is my first message to the list. I tried to be as clear as
possible. Thanks in advance for any help you can provide :)
QUESTION:
In short, ¿is it possible to call a stored procedure (inside package
"A") using parameters with types scoped in their own package "B"? how?
Long s
