try to resolve it!!!!!!!!

I am trying to use ref cursor as a return type to a function. I am taking this ref cursor value in java using cursor as data type. If cursor referring single table i can get column names cursor refers using ResultSetMetaData by setting %ROWTYPE. If my cursor refers to multiple tables what is the way to find out columns in java?

[351 byte] By [satish_gs] at [2007-9-26 2:37:26]

«« Preserve linebreaks from text to html
»» how to run kvm application

# 1

Did you have to write the whole question in bold? What do you mean, multiple tables? Are you joining tables in you SQL? If so, the resultsetmetadata should still work. If you don't like the names, just name the columns explicitly.

smiths at 2007-6-29 10:06:45 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

thanks smith,

it is working fine. I tried the sql query having many joins and observed the time taken for same query using functions (return type is cursor) and normal sql with java. It is taking more time for functions that normal sql why it is so?

Advance thanks,

Satish

satish_gs at 2007-6-29 10:06:45 >

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

try to resolve it!!!!!!!!

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified