Re: Connect Pl SQL
From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Mon, 05 Jul 1999 15:44:05 -0400
Message-ID: <37810B05.BDE9356E_at_Unforgettable.com>
Date: Mon, 05 Jul 1999 15:44:05 -0400
Message-ID: <37810B05.BDE9356E_at_Unforgettable.com>
You can't do that. You must establish your connection before you enter the pl/sql block.
Ken
Paolo Cassago wrote:
> Hi,
> I' m trying to establish a connection from a stored procedure and I'm
> using the follow instruction:
>
> is
> cid INTEGER;
> begin
> cid := DBMS_SQL.OPEN_CURSOR;
> DBMS_SQL.PARSE(cid, 'CONNECT user/passwd_at_serveroracle',
> dbms_sql.v7);
>
> But the follow errors occurs:
>
> ORA-00900: invalid SQL statement
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 491
> ORA-06512: at "SYS.DBMS_SQL", line 32
> ORA-06512: at "PAOLO.PROVAUT", line 5
> ORA-06512: at line 2
>
> Can someone help me?? Thank you. Bye
Received on Mon Jul 05 1999 - 21:44:05 CEST