Re: PREPARED Statement use in Query Browser (BUG?)
I'm having a similar issue. The statement below returns 'Query returned no resultset' in Query Browser, yet works fine from the command line (minus the transaction statements).
START TRANSACTION;
set @lst = "'Administrators', 'Users'";
set @sql = concat( 'select * from roles where RoleName in ( ', @lst, ' )' );
prepare statement from @sql;
execute statement;
COMMIT;
Subject
Written By
Posted
February 26, 2007 01:11PM
February 26, 2007 01:43PM
February 26, 2007 02:28PM
Re: PREPARED Statement use in Query Browser (BUG?)
February 29, 2008 06:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.