Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: problem calling procedure pl/sql with java

Re: problem calling procedure pl/sql with java

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 2 Mar 2007 10:24:25 -0800
Message-ID: <1172859865.591708.297020@31g2000cwt.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US