#include <iostream>
#include <vector>
using namespace std;
struct Employee
{
    char name[50];
}emp;
class EmployeeManager{
private:
    EmployeeManager(){

    }
    static EmployeeManager* mngr;
public:
    vector<Employee> emp_list();
    static EmployeeManager* create(){
        if (mngr==NULL)
            mngr = new EmployeeManager();
        return mngr;
    }
};
vector<Employee> EmployeeManager::emp_list(){
    vector<Employee> l;
    EXEC SQL WHENEVER SQLERROR do sql_error("Oracle error");
    EXEC SQL CONNECT :userid;
    EXEC SQL DECLARE emp_cursor CURSOR FOR
                SELECT ename from emp;
    EXEC SQL OPEN emp_cursor;
    EXEC SQL WHENEVER NOT FOUND DO break;
    while(1)
    {
        EXEC SQL FETCH emp_cursor INTO :emp;
        l.push_back(emp);
    }
    EXEC SQL CLOSE emp_cursor;
    EXEC SQL COMMIT WORK RELEASE;
}
int main(){
    return 0;
}