111: l_where_clause := l_where_clause || ' AND ROWNUM = 1';
112: l_query_clause := l_select_clause || l_from_clause || l_where_clause;
113:
114: --PREPARE the query for execution
115: c1 := dbms_sql.open_cursor;
116: dbms_sql.parse(c1, l_query_clause, dbms_sql.native);
117:
118: --go through the bind var values array and do the bindings
119: i := l_bind_vars.FIRST;
112: l_query_clause := l_select_clause || l_from_clause || l_where_clause;
113:
114: --PREPARE the query for execution
115: c1 := dbms_sql.open_cursor;
116: dbms_sql.parse(c1, l_query_clause, dbms_sql.native);
117:
118: --go through the bind var values array and do the bindings
119: i := l_bind_vars.FIRST;
120: WHILE (i IS NOT NULL) LOOP
117:
118: --go through the bind var values array and do the bindings
119: i := l_bind_vars.FIRST;
120: WHILE (i IS NOT NULL) LOOP
121: dbms_sql.bind_variable(c1, ':'||to_char(i), l_bind_vars(i));
122: i := l_bind_vars.NEXT(i);
123: END LOOP;
124:
125: --dummy return value
122: i := l_bind_vars.NEXT(i);
123: END LOOP;
124:
125: --dummy return value
126: dbms_sql.define_column(c1, 1, i);
127:
128: --EXECUTE the result check query
129: l_ignore := dbms_sql.execute(c1);
130:
125: --dummy return value
126: dbms_sql.define_column(c1, 1, i);
127:
128: --EXECUTE the result check query
129: l_ignore := dbms_sql.execute(c1);
130:
131: --if it returned a row, return success
132: IF dbms_sql.fetch_rows(c1) > 0 THEN
133: dbms_sql.close_cursor(c1);
128: --EXECUTE the result check query
129: l_ignore := dbms_sql.execute(c1);
130:
131: --if it returned a row, return success
132: IF dbms_sql.fetch_rows(c1) > 0 THEN
133: dbms_sql.close_cursor(c1);
134: return 'Y';
135: ELSE
136: dbms_sql.close_cursor(c1);
129: l_ignore := dbms_sql.execute(c1);
130:
131: --if it returned a row, return success
132: IF dbms_sql.fetch_rows(c1) > 0 THEN
133: dbms_sql.close_cursor(c1);
134: return 'Y';
135: ELSE
136: dbms_sql.close_cursor(c1);
137: return 'N';
132: IF dbms_sql.fetch_rows(c1) > 0 THEN
133: dbms_sql.close_cursor(c1);
134: return 'Y';
135: ELSE
136: dbms_sql.close_cursor(c1);
137: return 'N';
138: END IF;
139:
140: EXCEPTION