IT- 알파와 오메가

NO_DATA_FOUND error with query > QUESTION POSED ON: 08 February 2007 I am using this query in Pro*C: SELECT CALL_DIVERTED_NUM,SMS_DIVERTED_NUM,SMS_STRING,SMS_STATUS INTO :call_diverted:call_diverted_ind,:sms_diverted:sms_diverted_ind, :subs_sms_string:subs_sms_string_ind,:subs_profile FROM MCA_SUB_PROFILE WHERE MOBILENUM = :sqlv_mobilenum; I am getting the error "NO_DATA_FOUND." What do I ha..

/*-------------------------------------------------------------------- * Example Pro*C program to describe a database procedure and print * its arguments. * Frank Naude - Sep 2000 *-------------------------------------------------------------------- */ #define MAX_PLSQL_PARAMETERS 30 #include <stdlib.h> #include <stdio.h> #define SQLCA_INIT EXEC SQL INCLUDE sqlca; typedef char strz[3..

/*-------------------------------------------------------------------- * Very simple example Pro*C program to connect to more than one * database to do work. * Frank Naude - Sep 2000 *-------------------------------------------------------------------- */ #include <stdio.h> #include <sqlca.h> void sqlerror(); EXEC SQL BEGIN DECLARE SECTION; char *connstr1 = "scott/tiger"; char *conns..

/*-------------------------------------------------------------------- * Example Pro*C program to execute a database procedure with known * IN OUT arguments. * Frank Naude - Sep 2000 *-------------------------------------------------------------------- */ #include <stdio.h> #include <sqlca.h> void sqlerror(); EXEC SQL BEGIN DECLARE SECTION; char *sqlstmt = "begin :x := upper(:x); end..

/*-------------------------------------------------------------------- * Very simple example Pro*C program to select records from a database * * Frank Naude - Sep 2000 *-------------------------------------------------------------------- */ #include <stdio.h> #include <sqlca.h> void sqlerror(); EXEC SQL BEGIN DECLARE SECTION; char *connstr = "scott/tiger"; char db_ename[30]; int db_d..

/*-------------------------------------------------------------------- * Very simple example Pro*C program to fetch multiple records * from database * Frank Naude - Sep 2000 *-------------------------------------------------------------------- */ #include <stdio.h> #include <sqlca.h> void sqlerror(); EXEC SQL BEGIN DECLARE SECTION; char *connstr = "scott/tiger"; char db_ename[30]; in..