is there a JDBC equivalent to Oracle's PRO*C DESCRIBE operation?

I am porting code from Oracle's PRO*C to JDBC.

In PRO*C, if I have a text which represents an unknown SQL statement, I can
describe it and get the names (and number) of bind variables in it.

For example, describing

SELECT a,b from t where a= :bind1 and b= :bind2

Will return the result of two input bind variables, whose name is :bind1 and
:bind2. I can also get the names & types of the output variables (a & b in
this case).

Is there any JDBC equivalent for this (I know in JDBC binds are represented
as ?, however oracle-specific JDBC drivers also support the above syntax).

Thanks,
Ilan


.

Relevant Pages

  • Re: is there a JDBC equivalent to Oracles PRO*C DESCRIBE operation?
    ... In PRO*C, if I have a text which represents an unknown SQL statement, I can ... describe it and get the names of bind variables in it. ... Is there any JDBC equivalent for this (I know in JDBC binds are represented ... however oracle-specific JDBC drivers also support the above syntax). ...
    (comp.lang.java.programmer)
  • bind variables with jdbc
    ... oracle database 8.1.7 via jdbc. ... My DBA has just notify me that I am ... not using bind variables in my code and was wondering what i'll need ...
    (comp.lang.java.databases)
  • Re: is there a JDBC equivalent to Oracles PRO*C DESCRIBE operation?
    ... In PRO*C, if I have a text which represents an unknown SQL statement, I can ... describe it and get the names of bind variables in it. ... Is there any JDBC equivalent for this (I know in JDBC binds are represented ...
    (comp.lang.java.databases)
  • is there a JDBC equivalent to Oracles PRO*C DESCRIBE operation?
    ... I am porting code from Oracle's PRO*C to JDBC. ... In PRO*C, if I have a text which represents an unknown SQL statement, I can ... describe it and get the names of bind variables in it. ...
    (comp.lang.java.programmer)