proc问题
#include <string.h>
#include "sqlca.h"
#include "proc.h"
/************ Connect DataBase ****************/
int connectDB(char *usr_id)
{
char uid_pwd[100];
strcpy(uid_pwd, usr_id);
EXEC SQL CONNECT :uid_pwd;
if (sqlca.sqlcode == 0)
return 1;
else
return -sqlca.sqlcode;
}
/*********** insert into Talbe : t04_detail_X *******************/
int insertInto ( char* Login_name, char* Login_ip, char* in_date ,char* out_date, char* ip , int time ) {
EXEC SQL BEGIN DECLARE SECTION;
char Lab_Login_name[11];
char Lab_Login_ip[33];
char Lab_ip[33];
char login_date[20];
char logout_date[20];
int Time_duration;
EXEC SQL end DECLARE SECTION;
strcpy(Lab_Login_name, Login_name);
strcpy(Lab_Login_ip, Login_ip);
strcpy(login_date, in_date);
strcpy(logout_date, out_date);
strcpy(Lab_ip, ip);
Time_duration = time;
/**
EXEC SQL INSERT INTO t04_detail_1 values(TRIM(:Lab_Login_name),TRIM(:Lab_Login_ip),TO_DATE(:login_date,'dd-mm-yyyy'),TO_DATE(:logout_date,'dd-mm-yyyy'),TRIM(:Lab_ip),:Time_duration);
*/ 这里怎么调用pl/sql的存储过程???
EXEC SQL EXECUTE BEGIN
insert_detail04( :Lab_Login_name, :Lab_Login_ip, :login_date, :logout_date, :Lab_ip, :Time_duration );
END;
END-EXEC;
/**
if (sqlca.sqlcode == 0){
EXEC SQL COMMIT ;
return 1;
}
else{
EXEC SQL ROLLBACK ;
return -sqlca.sqlcode;
}
*/
}