"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. You would define a database link.
Jim
Received on Mon Jun 05 2006 - 09:35:13 CDT
