1. Getting PL/SQL tables from JDBC coderanch.comWhen all else fails, post. I'm running WebLogic 5.1 using their connection pooling with the Oracle thin driver (which we need to use at least for the time being). I've written some stored procedures (PL/SQL) that have parameters that are package-defined PL/SQL tables, and I'm having an absolute bear of a time trying to put in table parameters or get them ... |
2. Passing PL/SQL table from Stored Proc to Java coderanch.comMY scenario is something like this: I have to call a packaged PL/SQL proc from my Java program. The procedure should set a table of varchar as out parameter, which I can pick up in my Java program. This is the definition of the table type: type STR_ARRAY is table of varchar2(1000); I know how to pass a String array from ... |