tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mgai...@hotmail.com
Subject Re: PLS-00201: identifier '<package_name.procedure_name>' must be declared
Date Wed, 05 Dec 2007 16:35:01 GMT
JNDI was designed for DB access with and without schema classification

once you have a connection you can always alter your session to take a
schema
ALTER SESSION SET SCHEMA = schema_name

M--
----- Original Message -----
Wrom: NHGSWZIDREXCAXZOWCONEUQZAAFXISHJEXXI
To: <users@tomcat.apache.org>
Sent: Wednesday, December 05, 2007 9:55 AM
Subject: PLS-00201: identifier '<package_name.procedure_name>' must be
declared


> Hi,
>
> I am trying to call a stored procedure defined within a package in Oracle
> database from my servlet using java.sql.CallableStatement
> The connection is established using JNDI.
> I get the error:
> PLS-00201: identifier '<package_name.procedure_name>' must be declared
>
> However, the procedure gets executed when I try calling it with the schema
> name prefixed - '<schema_name.package_name.procedure_name>'. The
connection
> is established using the same schema credentials. I have given the
necessary
> grants to the database user/schema.
>
> Could you please let me know the following:
> 1. Do I necessarily need to mention the schema name to call the procedure.
> 2. If it is required how do I get the schema/user id from the JNDI
settings
> under Context.
>
> Thanks and Regards,
> Khalid Syed.
>


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message