Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: problem calling procedure pl/sql with java
On Mar 2, 10:19 am, "markux" <marco.pata..._at_gmail.com> wrote:
> Hi to all,
>
> I've a java class that call one procedure (in a package) with
> CallableStatement and it's work fine. (one param IN varchar e one OUT
> varchar)
>
> But this procedure call another procedure in an other package and this
> calling doesn't work. If I move in same package it works, but I don't
> move it in server production.
>
> exists one solution?
> thanx
> Mark
You have to check if the procedure in the second package is declared in the spec and if the first package user can execute the second one. For more details you should post your environment specifics. Received on Fri Mar 02 2007 - 12:24:25 CST
![]() |
![]() |