Dynamic PL/SQL and Stored Procedures

Here's some code. Also check out the March/April Oracle magazine which has a detailed article on Dynamic SQL.

procedure DYnamic_SQL is

	cur INTEGER; 
	ret INTEGER; 
	stmt VARCHAR2(2250); 
	subs INTEGER; 
	begin
		stmt :='select placeid from places'; 
		cur := dbms_sql.open_cursor;
		dbms_sql.parse(cur,stmt,dbms_sql.v7); 
		dbms_sql.define_column(cur,1,subs IN INTEGER);  --first define the
column
		ret := dbms_sql.execute(cur); 
		loop
			if dbms_sql.fetch_rows(cur) > 0 then
				dbms_sql.column_value(cur,1,subs);  --then slap a value in it
			else
				EXIT;
			end if;
		end loop;
		dbms_sql.close_cursor(cur);
	end;																		

Regards,

Park                                                   Received on Sun Mar 31 1996 - 00:00:00 CET