Pro*C ÖÐǶÈëpl/sql¿é

/* °üº¬CÍ·Îļþ */
#include <stdio.h>
#include <string.h>
#include <stdlib.h>
/* °üº¬SQLCAÍ·Îļþ */
EXEC SQL INCLUDE sqlca;
EXEC SQL INCLUDE sqlda;
int main()
{
    EXEC SQL BEGIN DECLARE SECTION;
    int  money;
    char answerbuff[200];
    int flag;
    EXEC SQL END DECLARE SECTION;
    /*
     * ¶¨ÒåÊäÈëËÞÖ÷±äÁ¿:½ÓÊÕÓû§Ãû¡¢¿ÚÁîºÍÍøÂç·þÎñÃû
     *
     */
    char username[10],password[10],server[10];
    strcpy(username,"data_center");
    strcpy(password,"data_center");
    strcpy(server,"oradf1"); /*ÕâÀïÌîдµÄÊÇÊý¾Ý¿âµÄSID*/
    /* Á¬½Óµ½Êý¾Ý¿â */
    EXEC SQL CONNECT :username IDENTIFIED BY :password USING :server;
    if (sqlca.sqlcode==0)
        printf("Á¬½Ó³É¹¦!\n");
    else
        /* ÏÔʾÁ¬½Ó´íÎóÏûÏ¢ */
        printf("%.*s\n", sqlca.sqlerrm.sqlerrml,
                sqlca.sqlerrm.sqlerrmc);
    /*³õʼ»¯*/
    money=0;
    flag=0; /*ÓÃÌìÅжÏÊÇ·ñÕÒµ½Êý¾Ý*/
    /*Ö´ÐÐplsql¿é*/
    EXEC SQL EXECUTE
        BEGIN
        SELECT salary INTO :money from plsqltest WHERE name='ht';
        :flag:=1;
    EXCEPTION
        WHEN NO_DATA_FOUND THEN
        :answerbuff:='Êý¾ÝûÓÐÕÒµ½';
    END;
    END-EXEC;
    /*Êä³ö½á¹û*/