Dynamic call of stored procedures.

Hi!

I have a table in oracle which contains information of a set of stored procedures which I want to run in batch.

I populate a cursor which contains procedure name. I then loop through the cursor and want to call the procedure using dynamic sql, but I can't get it to work. Anybody who can help me?

Part of the code is shown below. Is this the way of calling stored procedures dynamically?

open qa_cur;
loop

	fetch qa_cur into qa_rec;
	exit when qa_cur%NOTFOUND;

	-- process data record

	dbms_c1 := dbms_sql.open_cursor;
	dbms_sql.parse(dbms_c1,qa_rec.proc_name,dbms_sql.v7);
	rows := dbms_sql.execute(dbms_c1);
	dbms_sql.close_cursor(dbms_c1);

end loop;

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 15 1998 - 05:33:16 CDT