100:
101: println('table name:'||table_name);
102: println('sql:'||sqlstmt);
103:
104: cursor_handle := dbms_sql.open_cursor;
105: dbms_sql.parse(cursor_handle, sqlstmt, dbms_sql.v7);
106: -- dbms_sql.bind_variable(cursor_handle, 'table_name', table_name);
107: -- dbms_sql.bind_variable(cursor_handle, 'column_name', column_name);
108: -- dbms_sql.bind_variable(cursor_handle, 'oldfmt', oldfmt);
101: println('table name:'||table_name);
102: println('sql:'||sqlstmt);
103:
104: cursor_handle := dbms_sql.open_cursor;
105: dbms_sql.parse(cursor_handle, sqlstmt, dbms_sql.v7);
106: -- dbms_sql.bind_variable(cursor_handle, 'table_name', table_name);
107: -- dbms_sql.bind_variable(cursor_handle, 'column_name', column_name);
108: -- dbms_sql.bind_variable(cursor_handle, 'oldfmt', oldfmt);
109: -- dbms_sql.bind_variable(cursor_handle, 'newfmt', newfmt);
102: println('sql:'||sqlstmt);
103:
104: cursor_handle := dbms_sql.open_cursor;
105: dbms_sql.parse(cursor_handle, sqlstmt, dbms_sql.v7);
106: -- dbms_sql.bind_variable(cursor_handle, 'table_name', table_name);
107: -- dbms_sql.bind_variable(cursor_handle, 'column_name', column_name);
108: -- dbms_sql.bind_variable(cursor_handle, 'oldfmt', oldfmt);
109: -- dbms_sql.bind_variable(cursor_handle, 'newfmt', newfmt);
110: num_lines := dbms_sql.execute(cursor_handle);
103:
104: cursor_handle := dbms_sql.open_cursor;
105: dbms_sql.parse(cursor_handle, sqlstmt, dbms_sql.v7);
106: -- dbms_sql.bind_variable(cursor_handle, 'table_name', table_name);
107: -- dbms_sql.bind_variable(cursor_handle, 'column_name', column_name);
108: -- dbms_sql.bind_variable(cursor_handle, 'oldfmt', oldfmt);
109: -- dbms_sql.bind_variable(cursor_handle, 'newfmt', newfmt);
110: num_lines := dbms_sql.execute(cursor_handle);
111: dbms_sql.close_cursor(cursor_handle);
104: cursor_handle := dbms_sql.open_cursor;
105: dbms_sql.parse(cursor_handle, sqlstmt, dbms_sql.v7);
106: -- dbms_sql.bind_variable(cursor_handle, 'table_name', table_name);
107: -- dbms_sql.bind_variable(cursor_handle, 'column_name', column_name);
108: -- dbms_sql.bind_variable(cursor_handle, 'oldfmt', oldfmt);
109: -- dbms_sql.bind_variable(cursor_handle, 'newfmt', newfmt);
110: num_lines := dbms_sql.execute(cursor_handle);
111: dbms_sql.close_cursor(cursor_handle);
112: println('updated:' || To_char(num_lines));
105: dbms_sql.parse(cursor_handle, sqlstmt, dbms_sql.v7);
106: -- dbms_sql.bind_variable(cursor_handle, 'table_name', table_name);
107: -- dbms_sql.bind_variable(cursor_handle, 'column_name', column_name);
108: -- dbms_sql.bind_variable(cursor_handle, 'oldfmt', oldfmt);
109: -- dbms_sql.bind_variable(cursor_handle, 'newfmt', newfmt);
110: num_lines := dbms_sql.execute(cursor_handle);
111: dbms_sql.close_cursor(cursor_handle);
112: println('updated:' || To_char(num_lines));
113: EXCEPTION
106: -- dbms_sql.bind_variable(cursor_handle, 'table_name', table_name);
107: -- dbms_sql.bind_variable(cursor_handle, 'column_name', column_name);
108: -- dbms_sql.bind_variable(cursor_handle, 'oldfmt', oldfmt);
109: -- dbms_sql.bind_variable(cursor_handle, 'newfmt', newfmt);
110: num_lines := dbms_sql.execute(cursor_handle);
111: dbms_sql.close_cursor(cursor_handle);
112: println('updated:' || To_char(num_lines));
113: EXCEPTION
114: WHEN OTHERS THEN
107: -- dbms_sql.bind_variable(cursor_handle, 'column_name', column_name);
108: -- dbms_sql.bind_variable(cursor_handle, 'oldfmt', oldfmt);
109: -- dbms_sql.bind_variable(cursor_handle, 'newfmt', newfmt);
110: num_lines := dbms_sql.execute(cursor_handle);
111: dbms_sql.close_cursor(cursor_handle);
112: println('updated:' || To_char(num_lines));
113: EXCEPTION
114: WHEN OTHERS THEN
115: dbms_sql.close_cursor(cursor_handle);
111: dbms_sql.close_cursor(cursor_handle);
112: println('updated:' || To_char(num_lines));
113: EXCEPTION
114: WHEN OTHERS THEN
115: dbms_sql.close_cursor(cursor_handle);
116: println(Sqlerrm);
117: RAISE bad_parameter;
118: END;
119: