nasty one...

From: Giovanni Azua <bravegag_at_hotmail.com>
Date: Fri, 5 Dec 2003 16:56:38 +0100
Message-ID: <bqqa1n$25us2d$1@ID-114658.news.uni-berlin.de>

Hello all,

I have a PL/SQL procedure within user X. This procedure calls another procedure JSP say "A" also within X but this X java procedure does have to execute a DDL which is passed as a CLOB within ANOTHER user connection...

The question is whether from PL/SQL or Java how do I get a connection from user X to user Y given that I am within X. The thing gets even more complicated because chances are that Y is defined as a link to a remote database...

No way to hardcode or store the thin connection params.

Best regards,
Giovanni Received on Fri Dec 05 2003 - 09:56:38 CST