求助！关于oracle下的编程

postyw

操作系统是SCO 5.0.5，我想通过代码实现对oracle表中数据的添加，修改，删除，查询，使用c还是shell，最好给一个实例！万分感谢！！！

aocp

这个叫 Pro*C 程序.
参考 Pro*C 编程.
http://www.itdba.com/forum_view.asp?forum_id=34&view_id=249


Pro*c 简单实例
/*
*        filename:model.pc
*        author:alamo
*        inc:sinosoft
*        create time:2001.3.24
*        update time:
*        desc:it is a model file for write pro*c programe for oracle+tuxedo
*/

#include <stdio.h>;
#include <string.h>;
#include <stdlib.h>;
#include <sqlda.h>;
#include <sqlcpr.h>;
#include <atmi.h>;
#include <fml.h>;
#include <userlog.h>;

/* set pro*c operation */
exec sql include sqlca;
exec sql include oraca;
exec oracle option (oraca=yes);

/* Define constants for VARCHAR lengths. */
#define     UNAME_LEN      20
#define     PWD_LEN        40

/* Declare variables.  No declare section is
  needed if MODE=ORACLE. */
VARCHAR     username[UNAME_LEN];  /* VARCHAR is an Oracle-supplied struct */
varchar     password[PWD_LEN];    /* varchar can be in lower case also. */

/* Declare error handling function. */
void sql_error(msg)
   char *msg;
{
   char err_msg[128];
   size_t buf_len, msg_len;

   EXEC SQL WHENEVER SQLERROR CONTINUE;

   printf("
%s
", msg);
   buf_len = sizeof (err_msg);
   sqlglm(err_msg, &buf_len, &msg_len);
   printf("%.*s
", msg_len, err_msg);

   EXEC SQL ROLLBACK RELEASE;
   exit(EXIT_FAILURE);
}

void main()
{

/* Connect to ORACLE--
* Copy the username into the VARCHAR.
*/
   strncpy((char *) username.arr, "sgac_dec", UNAME_LEN);

/* Set the length component of the VARCHAR. */
   username.len =
     (unsigned short) strlen((char *) username.arr);

/* Copy the password. */
   strncpy((char *) password.arr, "dbwork", PWD_LEN);
   password.len =
     (unsigned short) strlen((char *) password.arr);

/* Register sql_error() as the error handler. */
   EXEC SQL WHENEVER SQLERROR DO sql_error("ORACLE error--
";

/* Connect to ORACLE.  Program will call sql_error()
* if an error occurs when connecting to the default database.
*/
   EXEC SQL CONNECT :username IDENTIFIED BY :password;

   printf("
Connected to ORACLE as user: %s
", username.arr);

/* Disconnect from ORACLE. */
   EXEC SQL ROLLBACK WORK RELEASE;
   exit(EXIT_SUCCESS);
}

postyw

这个c程序怎样编译？？？并且数据库的用户名及密码在那验证？？？