1. When should you use java stored procedures with an Oracle database ... what are the drawbacks? stackoverflow.comPL/SQL is not my native tongue. Oracle supports writing stored procedures in Java. What are the advantages of doing this over writing the stored procedures in PL/SQL |
2. How to pass Map to Oracle PL/SQL function? stackoverflow.comI would like to create an equivalent if this Java method as PL/SQL function in Oracle 10g:
Is it possible to pass a Map (or some simillar ... |
3. Launch Oracle stored-procedure in Java code stackoverflow.comI wrote a stored-procedure in Oracle and now, I want to launch it in Java code. I will describe a problem. I have a object type:
|
4. Call PL/SQL Web Toolkit procedures from Java stackoverflow.comI need to call some PL/SQL procedures from my Java application. I can do it with JDBC. But the problem is that procedures are using the "PL/SQL Web Toolkit" ... |
5. how can the PL/SQL datatype BINARY_INTEGER materialized as Java types? stackoverflow.comWhat would be the datatype in java equivalent to the PL/SQL datatype BINARY_INTEGER? |
6. Are there different methods to call Java from Oracle Application Express stackoverflow.comFriends, I'm working on a requirement where I need to call a Java API from Apex. The solution I put forward was to create a Java class, store it the database ... |
7. Oracle stored function/procedure with VARRAY or user-defined type as IN parameter stackoverflow.comI've defined VARRAY of a user-defined type such as this :
|
8. Are anonymous blocks stored parsed in the SGA? stackoverflow.comI have discovered recently that's possible to call anoymous blocks from jdbc like this: String plsql = "BEGIN" + ... |
9. How can I generate list of classes in order of dependency? stackoverflow.comI'm doing a build script for a Java application to run inside the Oracle JVM. In order to import the 50-odd classes, it appears I need to bring them in in ... |
10. Problem trying to export java source code from an Oracle database stackoverflow.comI am trying to export the source for a java object from an oracle database using the following code.
Whenever ... |
11. Calling an Oracle PL/SQL procedure with Custom Object return types from 0jdbc6 JDBCthin drivers stackoverflow.comI'm writing some JDBC code which calls a Oracle 11g PL/SQL procdedure which has a Custom Object return type. Whenever I try an register my return types, I get either ... |
12. Accessing the Custom Object Return type from ojdbc6 JDBC Thin Drivers stackoverflow.comI'm writing some JDBC code which calls a Oracle 11g PL/SQL procdedure which has a Custom Object return type. I can get the code to call the procedure, but how do ... |
13. Invoking a PL/SQL function from EclipseLink stackoverflow.comI'm trying to execute a PL/SQL function in EclipseLink which uses Oracle Specific types(eg. Boolean). I've tried using PLSQLStoredProcedureCall which complains that I'm not executing a procedure and I have tried using ... |
14. Using UTL_FILE to pull data from an Oracle server to a local file system using JDBC? stackoverflow.comI need to consume a file that is being generated on an Oracle server and I have been told to get it using the UTL_FILE package. I intend on consuming ... |
15. JDBC result set from an Oracle PL/SQL stored procedure stackoverflow.comWhat does oracleClose() and oracleCloseQuery() do in sqlj.runtime.ExecutionContext.OracleContext.
Since we upgraded jdbc driver jar to |
16. Java: Send array to a PL-SQL function stackoverflow.comI need to pass an array of objects to a PL-SQL function My ORACLE code:
|
17. Applying Oracle PL/SQL via JDBC stackoverflow.comIs it possible to create/replace PL/SQL via the Oracle JDBC driver, i.e not via SQLPLus* ?
Update 1: Driver: ojdbc14 (JDBC)
Update 2: Change is being applied to oracle via Ant |
18. JDBC + PL/SQL = Is it so simple, or is there a catch? stackoverflow.comI am planning to execute Oracle PL\SQL blocks via JDBC (can't test it yet, question of few days). Is there anything I should know? Does everything work as it used to ... |
19. Using Java in Oracle database stackoverflow.commy current java code is deployed to the DB and the plsql code calls it and uses it. I need to get the Java code out of the database and still be ... |
20. Oracle Store Procedures Automation stackoverflow.comI am currently working on the process of automating the creation of store procedure and functions in oracle DB I am using java to automate the process of creating store procedures ... |
21. Implement the Business Services in PL/SQL or Java? Favor/Cons? stackoverflow.comI work for an enterprise that will create a web-service stack architecture (probability rest based), im the technical leader envolved. This architecture will be created using the Java Platform, but I ... |
22. Assertion failure Aurora (ORA-29516) in Oracle 10g on loadjava stackoverflow.com
and I load it into oracle via
|
23. How to setup concurrent calls in Oracle 10g Java VM stackoverflow.comIf somebody can explain me how to properly configure plsql java wrapper when different database users invoke same procedure to ensure correct concurrent resource access handling. DBMS and JAVA: Oracle 10g, internal ... |
24. how to write a oracle function to update tables on different schemas stackoverflow.comhello i'm porting a wbsphere application to tomcat, i have to work on two database on the same server and i've integrated tomcat with atomikos transactionessential. This is my first project with ... |
25. Creating function in an Oracle database using java directly stackoverflow.comI understand that it is possible to create java function in an oracle database using the command CREATE JAVA - look here. I have been reading a lot ... |
26. Call Java Cryptography Architecture (JCA) from PL/SQL stackoverflow.comIs it possible to access (call) Java Cryptography Architecture (JCA) classes from PL/SQL? For example, when stored procedure are running. P.S. The big task is to validate digital signature (RSA) in PL/SQL. ... |
27. Pl/sql %RowType in JDBC stackoverflow.comI have been trying to execute a Oracle Stored procedure which returns %ROWTYPE using JDBC, as i mentioned below
|
28. oracle 11g database and java 1.5 problem stackoverflow.com
|
29. Executing PL/SQL Begin/End procedure from Oracle JDBC thin driver stackoverflow.comI am trying to create Oracle PL/SQL procedures and execute them via Oracle JDBC (thin driver). Here is the full PL/SQL script:
|
30. How to pass a List<> to an Oracle stored procedure stackoverflow.comI have code that already stores String data inside a SQL table using a stored procedure:
|
31. Call Oracle object-oriented PL/SQL member procedures from JDBC stackoverflow.comIn object-oriented PL/SQL, I can add member procedures and functions to types. An example is given here:
|
32. Money computations, comparison between java and Oracle/PL SQL which to use stackoverflow.comGuys can you give a good comparison regarding Oracle/PL SQL and Java in terms of their strengths and weaknesses when handling monetary computations. If you were to develop an application ... |
33. Trying to run PL/SQL script using Java stackoverflow.comI'm familiar with Java JDBC and use it often to run simple SQLs. However, I want to run something like the below. This is more PL/SQL than regular SQL, hence my ... |
34. using record types - declaration and body in package stackoverflow.comI have problem with my package its looks like:
|
35. How to return an array from Java to PL/SQL? stackoverflow.comI have no problems to pass numbers and strings back and forth from PL/SQL to Java, but how do I pass arrays ? I'm calling Java from PL/SQL - not other ... |
36. xml publisher template stackoverflow.comI am trying to edit the template on the data definitions "Standard Purchase Order Data Source". Unfortunately I am not able to edit the template as the update button wont enable. Could ... |
37. Cannot read value from SYS_CONTEXT stackoverflow.comI have a PL/SQL procedure which sets some variable in user session, like the following:-
|
38. How do I call by JDBC a PL/SQL function that returns an UDO and interpret that result? stackoverflow.comSay my UDO (user defined object) is:
And I have a PL/SQL function
|
39. oracle pl/sql stored proc and %rowtype with jdbc coderanch.com |
40. Oracle exam 1Z0-147 Program with PL/SQL ? coderanch.com |
41. Advice: Need a path for a quick start in using Java and Oracle PL/SQL coderanch.comGood Afternoon, all; Recently, I changed careers from HP Openview Administrator to Oracle Developer at an urban University in Detroit, Michigan. I get all of the PL/SQL I can eat . . .I mean type, but, I am greedy!! I have a novice Java background, but no place to exercise it on a daily basis. And, I see how much you ... |
42. JDBC call to PLSQL block having Oracle type object parameter coderanch.comHi Guys, I have been atempting migration from Oracle 9i to 10g(both app server and DB) for my application and am stuck on two issues related to Oracle TYPE parameters. 1. When the "Type" parameter in IN/OUT we get the "protocol violation" error, and if we change the parameter to just IN it completes the JDBC call successfully without error. 2. ... |
43. How can I call java class methods in Oracle 10g PL/SQL java-forums.orgHello, I have a problem. I want to call my java class and method from Oracle 10g PL/SQL. But I don't know how I can do this. Simply I do the following application. In server side PL/SQL read data from forms and moves this data to the file. In java class, the java method opens the file with given path and ... |
44. Oracle and PL/SQL 10g Training CDs and Multiple versions of Java... java-forums.orgContext: I'm in the middle of training myself how to use Oracle and the PL/SQL technology with the 10g training CDs. These CDs are part of the "Oracle University Technology-Based Training" and I believe they came with some of the books I acquired through a co-worker... Each CD provides movie-like sequences that explain whatever aspects each disc covers, complete with audio ... |
45. oracle pl/sql forums.oracle.comI am a java daveloper and have poor sql skills but sometimes you come across a situation where you have to manipulate data yourslef and thats why I am here. I know this is not an oracle forum but i am hopeful since this is a basic question somebody would be able to help. I want to run the following commands ... |
46. how to implement asynchronous invocation of oracle PL/SQL stored procedure forums.oracle.comHi friends! Is there any way to invoke pl/sql stored procedures asynchronously from inside a standard client-server application (not j2ee application)? I wonder if it is possible without using a dedicated application server. So i'm not planning to create or deploy any middle tier components as well as to deploy my pl/sql procedure as a web service... Thanks in advance . ... |
47. Returning Oracle PLSQL Array to Java code ( incorrect Array type code) forums.oracle.com----- Java Code calling the PLSQL function to return an array ----- import java.sql.*; import oracle.jdbc.driver.*; import oracle.sql.*; class Array { public static void main(String args[]) throws Exception { DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@ccdev3:1521:CAM2D3","hst","hst"); OracleCallableStatement stmt = (OracleCallableStatement)conn.prepareCall( "begin ? := TEST_PKG_FP.getSimpleArray; end;" ); // The name we use below, SIMPLEARRAY, matches the name of our // type we defined ... |