Re: SQL connect, how
From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: 2000/08/12
Message-ID: <spb97ojkn4t51_at_corp.supernews.com>#1/1
Date: 2000/08/12
Message-ID: <spb97ojkn4t51_at_corp.supernews.com>#1/1
<actiris_at_loxinfo.co.th> wrote in message news:8n0fk6$1ue$1_at_news1.sunrise.ch...
> On SQL plus
> connect user/psw_at_connection;
> works OK but
>
> How to connect in a Procedure
> if I try
> connect user/psw_at_connection;
> I get PLS-00103 problem connect
> if I try
> exec sql connect user/psw_at_connection;
> I get PLS-00103 sql
>
> Thankx for the tip
Not sure, but I think you might have to use the DBMS_SQL package or something like that to execute such a statement from inside PL/SQL. See what DBMS_% packages there are on your system - I'm pretty sure one of them is what you need - just not sure specifically which one.
-Matt Received on Sat Aug 12 2000 - 00:00:00 CEST