Re: nasty one...

Giovanni Azua wrote:

> 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

Time to go back to the drawing board. There is no reason you should be executing any DDL in the database. If you think otherwise I suggest you stop presenting "your" solution and present your "problem."

What you are doing, and I don't say this as an insult, is approaching the database as though you are a front-end developer who truly doesn't understand the database and how it works.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)