Xref: alice comp.databases.oracle.server:33476
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news.mel.connect.com.au!news.syd.connect.com.au!nsw.nntp.telstra.net!newshost.fujitsu.com.au!news
From: "Saurabh Sahai" <sahais@fast.fujitsu.com.au>
Newsgroups: comp.databases.oracle.server
Subject: Enumerating stored procedures & their columns
Date: 11 Nov 1998 09:19:38 GMT
Organization: FAST
Lines: 23
Message-ID: <01be0d54$ad538b20$7ad2ac89@koshtia>
X-Newsreader: Microsoft Internet News 4.70.1155

Hi,
I'm trying to enumerate all the stores procedures under a particular schema
CT3 in a database CT1, which is not the default database, using the
getProcedures method of databasemetadata in a JDBC program. I specify 
CATALOG  = null
SCHEMA = "CT3"
PROCEDURE NAME = "%"
This returns the right results using the JDBC OCI driver. But, using the
JDBC thin driver returns no results. 
The thin driver enumerates all the procedures in all the schemas if i
specify
CATALOG  = null
SCHEMA = "%"
PROCEDURE NAME = "%"
But I can't specify a specific schema as a search criterion.
Is this a known bug, in the thin driver, or am i doing something wrong?
Hoping that someone may help me explain this behaviour.

Regards,
Anjali Koshti
-- 
___________________________________
Copyright - Fujitsu Australia Limited