Hi I always get an error when executing this procedure
CREATE OR REPLACE PROCEDURE NEWCON1
AS
cursor_handle INTEGER := DBMS_SQL.OPEN_CURSOR;
seq_sql VARCHAR(200) := 'connect user/pass';
execute_ddl INTEGER;
BEGIN
DBMS_SQL.parse (cursor_handle,seq_sql, DBMS_SQL.NATIVE);
execute_ddl := DBMS_SQL.execute (cursor_handle);
DBMS_SQL.close_cursor (cursor_handle);
exception
when others
then
raise;
END;
/