Re: a little of pl/sql

"T" <t_at_yahoo.com> wrote in message news:e61enr$t41$1_at_ss408.t-com.hr...
:
:
: create or replace procedure connect_procedure as
:
:
: begin
:
:
: connect system/manager_at_oracle.world
:
: end;
:
:
:
: this procedure cannot be executed because
:
: The following error has occurred:
:
: ORA-00900: invalid SQL statement
:
:
:
: Is any other way to connect to other database ( create session ) through
: procedure..??
:
:

no ... what are you trying to accomplish? likely it can be down wth grants and roles (or a database link if the objects are actually in another database, not just another schema)

could you give a few more details about your process and environment?

++ mcs Received on Wed Jun 07 2006 - 06:39:03 CDT