Problem with procedure to connect as anouther user

[truma1]

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;
/

[jovery]

I don't think you can connect as another user within a procedure (unless you do so via a database link).

Regards

[ales]

"Connect user/pass" is a SQL*Plus command, not a SQL or PL/SQL command, you cannot use it outside SQL*Plus.

[Minesh]

You can use java store procedure to connect as a diffrent user or to check user name and password.

Minesh