// Open a database connection
oracle::occi::Connection* connection = LBCDatabase::instance().getConnection();

// Structures to store results
int numberOfLinks = model.numberOfLinksOfType(linkType) / 2;

char** simulationIdBuffer = new char*[numberOfLinks];
char** linkIdBuffer = new char*[numberOfLinks];
char** linkTypeBuffer = new char*[numberOfLinks];

unsigned short* simulationIdBufferLength = new unsigned short[numberOfLinks];
unsigned short* linkIdBufferLength = new unsigned short[numberOfLinks];
unsigned short* linkTypeBufferLength = new unsigned short[numberOfLinks];

// Simulation id is common for all links
std::string simulationId = model.simulationId();

// Loop on FWD links
int linkIndex{ 0 };
for (const std::shared_ptr<Link>& link : model.links())
{
    // Skip RTN links and FWD links UP
    if (ELinkType::RTN == link->linkType() ||
        (ELinkType::FWD == link->linkType() && ELinkSide::UP == link->linkSide()))
        continue;

    // Get datas for current link
    std::string linkId = LBCUtils::restoreLinkId(link->linkId());
    std::string linkType = LBCUtils::enumToString<ELinkType>(link->linkType());

    // Add them into buffers
    simulationIdBuffer[linkIndex] = new char[simulationId.length() + 1];
    std::strcpy(simulationIdBuffer[linkIndex], simulationId.c_str());

    linkIdBuffer[linkIndex] = new char[linkId.length() + 1];
    std::strcpy(linkIdBuffer[linkIndex], linkId.c_str());

    linkTypeBuffer[linkIndex] = new char[linkType.length() + 1];
    std::strcpy(linkTypeBuffer[linkIndex], linkType.c_str());

    // Store the length
    simulationIdBufferLength[linkIndex] = simulationId.length() + 1;
    linkIdBufferLength[linkIndex] = linkId.length() + 1;
    linkTypeBufferLength[linkIndex] = linkType.length() + 1;

    ++linkIndex;
}

// Create the query
std::string query("INSERT INTO res_link ");
query.append("(simulation_id, link_id, link_type) ");
query.append("VALUES(:1, :2, :3)");

oracle::occi::Statement* statement = connection->createStatement(query);
statement->setDataBuffer(1, (dvoid*)simulationIdBuffer, oracle::occi::OCCI_SQLT_STR, sizeof(simulationIdBuffer[0]), simulationIdBufferLength);
statement->setDataBuffer(2, (dvoid*)linkIdBuffer, oracle::occi::OCCI_SQLT_STR, sizeof(linkIdBuffer[0]), linkIdBufferLength);
statement->setDataBuffer(3, (dvoid*)linkTypeBuffer, oracle::occi::OCCI_SQLT_STR, sizeof(linkTypeBuffer[0]), linkTypeBufferLength);

// Execute the query
statement->executeArrayUpdate(numberOfLinks);   // Exception here: ORA-01480: trailing null missing from STR bind value
connection->commit();

// Cleanup buffers
delete[] simulationIdBufferLength;
delete[] linkIdBufferLength;
delete[] linkTypeBufferLength;
LBCUtils::deleteCharBuffer(simulationIdBuffer, numberOfLinks);
LBCUtils::deleteCharBuffer(linkIdBuffer, numberOfLinks);
LBCUtils::deleteCharBuffer(linkTypeBuffer, numberOfLinks);

// Cleanup before to go out
connection->terminateStatement(statement);
LBCDatabase::instance().releaseConnection(connection);