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


shib wrote:

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


Use the stored procedures to improve the performance of the JDBC.

4th type of drive is high performance driver..
Read Oracle JDBC Book for more information

http://d.1asphost.com/javaj2ee/ebooks/


Thanks

.

Relevant Pages