SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Output for sql type is different between sql command line and metadata

870275Jun 21 2011 — edited Jun 21 2011

There is a table type 'abc' of varchar2
created a stored procedure 'stp' using 'abc' as in parameter
now when 'desc stp' command is used in sql command line i.e, isqlplus, in the output the type of in parameter is shown as 'abc'
where as in case DatabaseMetaData.getProcedureColumns() is used, the resultSet contains the type of in parameter as 'table'
am using ojdbc5.jar
why is the difference between these two? is this a bug?
is there anyway that i could get the type of in parameter as 'abc' by using databaseMetaData

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 19 2011

Added on Jun 21 2011

3 comments

177 views