How can I get the list of only user defined Stored Procedures?

Greenhorn

Posts: 24

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I'm using getProcedures(.....) of DatabaseMetadata. I want to get list of only user defined stored procedures, but getProcedures gives me list of both(user+system).

Thanks
Amrit

Jeanne Boyarsky

author & internet detective

Posts: 42160

937

I like...

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Amrit,
What database are you using? Many databases, such as db2 and Oracle, keep user defined stored procs under the userid/schema. This is one of the arguments that can be based to getProcedures().

[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Java 8 (verified skill)
Skill verified by Jeanne Boyarsky

JUnit 5 (verified skill)
Skill verified by Jeanne Boyarsky

Amrit Tiwana

Greenhorn

Posts: 24

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Jeanne, I'm using SQL Server 2000. As in default, Northwind database I want to filter out the stored procedures with TYPE = 'System'.

Jeanne Boyarsky

author & internet detective

Posts: 42160

937

I like...

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Amrit,
It looks like Sql Server has an owner for each stored procedure too. Try filtering on that. You will need to know the owner of your stored proc because you can't say all except system.

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.