Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: nasty one...
"Giovanni Azua" <bravegag_at_hotmail.com> wrote in message news:<bqqa1n$25us2d$1_at_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
DDL sometimes just doesn't work and should be done manually. I was going to suggest an autonomous transaction with code to verify that it worked, but sounds like you would get ORA 164. Implicit commits with DDL tend to screw up transactional processing anyways.
jg
-- @home.com is bogus. "I don't even know what I'm _talking_ about!" - CostelloReceived on Fri Dec 05 2003 - 16:42:07 CST