Retrieve PL/SQL parameters 1

[Diancecht]

Hi all.

I'm trying to build a generic class to execute stored procedures.

What I want to achieve is to get the name of the procedure, manage to get the parameters and show a form to the user to get the input values.

Now I'm stuck on how to dynamically retrieve the parameter names and types. Looks like you need to know them from the procedure declaration.

What I'm trying to do is a kind of reflection with stored prodecures.

Does anyone know any hint to achieve this?

Thanks in advance,
Dian

 

[Diancecht]

I've found it, at least for Oracle, by querying the ALL_ARGUMENTS system table.

After some search, I don't think there's a way to do it from Java.

Cheers,
Dian

 

[feherke]

Hi

We use [tt]DatabaseMetaData.getProcedureColumns()[/tt] :

Connection con=[gray]/*...*/[/gray];
DatabaseMetaData dmd=con.getMetaData();
ResultSet res=dmd.getProcedureColumns(null,[i]"schema_name"[/i],[i]procedure_name"[/i],null);

If I understand you correctly.

Feherke.

http://rootshell.be/~feherke/

 

[Diancecht]

That's exactly what I needed.

Thank you very much.

Dian.