What's wrong with this sp?

Create procedure first_Oracle_sp(v_owner IN varchar2, v_tn IN varchar2)

			AS	
			Begin
				select distinct cols.table_name as tblname,c.nullable, cols.column_name
				from dba_constraints cons, dba_cons_columns cols, dba_tab_columns c
				where cons.table_name = cols.table_name 
				and cons.owner = v_owner
				and c.table_name = v_tn
				and cols.column_name = c.column_name
				and cons.constraint_name = cols.constraint_name
				and cons.constraint_type = 'R'
				and cons.table_name = v_tn
			End;

Thanks. Received on Mon Nov 12 2001 - 18:29:40 CET