Stored procedures and dynamic SQL

        dbms_sql.close_cursor(cid);
                raise;

/*

• Call format: exec exec_create_table_sp('sp_name', 'arg');
  *
  
• I have tried using the exec command and using bind but
• to no avail.
  *
  
• When I make the call, I get a SQL syntax error. HELP??
  */
  

/* **************************************************** 

• PROBLEM 2: creating a table within a sp by passing it a table name.
  *
  
• Problem here is that although we can create the table
• outside of this call, it gives us an error when try
• to create it within this sp. I believe the actual error
• is not the 'heart' of the problem and only a side effect.
  */
  CREATE OR REPLACE PROCEDURE exec_create_table_sp(tname IN VARCHAR2) AS cid INTEGER; val integer; BEGIN cid := dbms_sql.open_cursor;

    dbms_sql.parse(cid, 'CREATE TABLE ' || tname ||

                        ' (myname   varchar2(50) NOT NULL)'
                                        , dbms_sql.v7);