Comments - how can i transfer data use cursor

9 years, 7 months ago bhdbing bhdbing

ok i will make a example for that: create table emp ( name varchar(20), age number(2), city varchar(20) );

9 years, 7 months ago bhdbing bhdbing

in oracle create a procedurue:

create or replace procedure find( rs out sys_refcursor) is begin

open rs for select * from emp;


9 years, 7 months ago bhdbing bhdbing

execute this procedure in TOAD i can get the all info about my employees,and how to translate it to MariaDB?

9 years, 7 months ago roberto spadim

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

9 years, 7 months ago bhdbing bhdbing

sorry i can't connect to that site.

may be you can send your email address to email address is

in my current db,we use many cursor for transfer if i must create temporary table,that will be a big trouble to me. could you give me some advice? Thank you!

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.