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

[shib]

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

[IchBin]

Post by shib
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

If i understand you correctly then sure look at the PREPARE statement.

[Balaji]

Post by shib
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

[[e-mail]]

Post by shib
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

Hi. The closest equivalent is PreparedStatement.getMetaData(). You
would
create a prepared statement with the SQL, and then get the metadata.
Joe Weinstein at BEA Systems