Connect to diff user in PL/SQL

From: Tom Best <tom.best_at_bentley.com>
Date: Thu, 17 Jun 1999 16:45:04 -0400
Message-ID: <37695E50.210BB922@bentley.com>

Is there a way to connect to a different user and proceed issuing SQL statements within a PL/SQL procedure? This is what I tried, and I get Invalid SQL Statement at tunr time:

	    v_GeneralSQL := 'connect ' || v_username || '/' || v_userpwd;
		v_GeneralCursor := DBMS_SQL.OPEN_CURSOR;
		DBMS_SQL.PARSE (v_GeneralCursor, v_GeneralSQL, DBMS_SQL.V7);
		v_Dummy := DBMS_SQL.EXECUTE(v_GeneralCursor);
		DBMS_SQL.CLOSE_CURSOR(v_GeneralCursor);

Thanks.
Tom Best Received on Thu Jun 17 1999 - 15:45:04 CDT