You can print the 'sqlcode' as follows

Exception 
When others then
dbms_output.put_line('error code is'||sqlcode)
end; 

EXCEPTION
WHEN No_privilages THEN
htp.p( '
 Access denied
');
WHEN Rec_expired THEN
htp.p('Other user has changed this record,Query the record and 
Update');
WHEN OTHERS THEN
Htp.p(SQLERRM);

BLOB is Binary Large ObjectWhen you declare any variable as image, text, ntext ... they would be BLOB data typesText = 2^31-1text = 2^30-1ntext = 2^31-1-Each text, ntext, image colum can in a table ca...

HI ALL,try this..,create or replace procedure ddl_proc(tabname in varchar2)asv_cursor INTEGER;ddl_exe INTEGER;beginv_cursor:=Dbms_sql.open_cursor;Dbms_sql.Parse(v_cursor,' Create Table '||tabn...

We can use DDL commands in Procedure & Functions through
"EXECUTE IMMEDIATE " Command