Answer Posted / Rekha Rai
To return an array from Java to PL/SQL, you can use Java SQL Callable Statements. First, define the Java method that takes a parameter of type OracleArray and uses it as needed. Then, create an instance of the OracleArray, set its elements, and call the stored procedure with the array as a parameter.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the current version of postgresql?
what is bcp? When does it used? : Sql dba
what are all the common sql function? : Sql dba
what is dbms? : Sql dba
how to start mysql server? : Sql dba
Is primary key clustered index?
Do we need to rebuild index after truncate?
What is the best sql course?
Is inner join faster than left join?
Is primary key always clustered index?
what are the advantages of sql ? : Sql dba
what is collation? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
how to escape special characters in sql statements? : Sql dba
Can we rollback truncate?
