linux 安装 pro c

# 下载适合你系统的Instant Client Basic和SDK包
# 例如，对于64位Linux系统：
wget https://download.oracle.com/otn_software/linux/instantclient/instantclient-basic-linuxx64.zip
wget https://download.oracle.com/otn_software/linux/instantclient/instantclient-sdk-linuxx64.zip

# 解压文件
unzip instantclient-basic-linuxx64.zip -d /opt/oracle
unzip instantclient-sdk-linuxx64.zip -d /opt/oracle

# 创建符号链接以便于版本管理
ln -s /opt/oracle/instantclient_XX_X /opt/oracle/instantclient

export ORACLE_HOME=/opt/oracle/instantclient
export PATH=$ORACLE_HOME:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH

#include <stdio.h>
#include <stdlib.h>
#include <sqlca.h>

int main() {
    EXEC SQL BEGIN DECLARE SECTION;
        VARCHAR username[30];
        VARCHAR password[30];
        VARCHAR database[30];
    EXEC SQL END DECLARE SECTION;

    strcpy(username.arr, "your_username");
    username.len = strlen(username.arr);
    strcpy(password.arr, "your_password");
    password.len = strlen(password.arr);
    strcpy(database.arr, "your_database");
    database.len = strlen(database.arr);

    EXEC SQL CONNECT :username IDENTIFIED BY :password USING :database;

    if (sqlca.sqlcode != 0) {
        printf("Connection failed\n");
        exit(1);
    }

    printf("Connected to Oracle database\n");

    EXEC SQL COMMIT WORK RELEASE;

    return 0;
}

proc iname=your_program.pc oname=your_program.c
gcc -o your_program your_program.c -I$ORACLE_HOME/sdk/include -L$ORACLE_HOME -lclntsh
./your_program