Comments - how can i transfer data use cursor
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
check this: http://dev.mysql.com/doc/refman/5.6/en/cursor-restrictions.html
ok i will make a example for that: create table emp ( name varchar(20), age number(2), city varchar(20) );
in oracle create a procedurue:
create or replace procedure find( rs out sys_refcursor) is begin
open rs for select * from emp;
execute this procedure in TOAD i can get the all info about my employees,and how to translate it to MariaDB?
and what you want with procedure find? what you will do next? how other thread will read it in oracle?
i think this is a bit 'impossible' since in mariadb the rs variable is only to function scope, not to global scope... but must check
use pastebin to send examples of code, it's better than this wiki markup
sorry i can't connect to that site.
may be you can send your email address to me.my email address is firstname.lastname@example.org.
in my current db,we use many cursor for transfer data.so if i must create temporary table,that will be a big trouble to me. could you give me some advice? Thank you!