PL/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
|
I would like to create an equivalent if this Java method as PL/SQL function in Oracle 10g:
String myMethod(int par1, Map<String, Object> par2);
Is it possible to pass a Map (or some simillar ... |
I 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:
TYPE PERSON_TYPE AS OBJECT (ID NUMBER(38), NAME ...
|
I 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" ... |
What would be the datatype in java equivalent to the PL/SQL datatype BINARY_INTEGER?
|
Friends,
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 ... |
I've defined VARRAY of a user-defined type such as this :
CREATE OR REPLACE TYPE TEST_T AS OBJECT
(C1 VARCHAR2(20 BYTE), C2 VARCHAR2 (11 Byte));
CREATE OR REPLACE TYPE ...
|
|
I have discovered recently that's possible to call anoymous blocks from jdbc like this:
String plsql = "BEGIN" +
... |
I'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 ... |
I am trying to export the source for a java object from an oracle database using the following code.
DECLARE
blob1 BLOB;
BEGIN
DBMS_LOB.CREATETEMPORARY(blob1, FALSE);
DBMS_JAVA.EXPORT_SOURCE('OBJECTNAME', 'SCHEMANAME', blob1);
END;
Whenever ... |
I'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 ... |
I'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 ... |
I'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 ... |
I 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 ... |
What does oracleClose() and oracleCloseQuery() do in sqlj.runtime.ExecutionContext.OracleContext.
Since we upgraded jdbc driver jar to ojdbc5.jar with the oracleClose() in the finally block we get the below exception when using resultset.next() ... |
I need to pass an array of objects to a PL-SQL function
My ORACLE code:
CREATE OR REPLACE
TYPE
uu.ITEMTAB AS TABLE OF ITEMREC;
/
CREATE OR REPLACE
TYPE
...
|
Is 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 <SQL> task, ... |
I 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 ... |
my 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 ... |
I 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 ... |
I 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 ... |
public class HelloWorld{
public static void add(int a, int b){
System.out.println(a+b);
}
}
and I load it into oracle via
loadjava -user ...
|
If 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 ... |
hello
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 ... |
I 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 ... |
Is 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.
... |
I have been trying to execute a Oracle Stored procedure which returns %ROWTYPE using JDBC, as i mentioned below
OracleCallableStatement ocs = (OracleCallableStatement)conn.prepareCall("begin <PackageName>.procedureName(?,?,?,?); end; ");
ocs.setString(1, "001");
...
|
^
x.vmesniki.frkws.X.runtime.XX_LiteralSerializer:32: cannot find symbol
symbol : class CombinedSerializer
location: class x.vmesniki.frkws.X.runtime.XX_LiteralSerializer
private CombinedSerializer myns2_string__java_lang_String_String_Serializer;
...
|
I am trying to create Oracle PL/SQL procedures and execute them via Oracle JDBC (thin driver). Here is the full PL/SQL script:
begin
for i in (select owner, constraint_name, table_name from all_constraints ...
|
I have code that already stores String data inside a SQL table using a stored procedure:
// my DAO
public class SomeProcedure extends StoredProcedure {
public void process (String data) ...
|
In object-oriented PL/SQL, I can add member procedures and functions to types. An example is given here:
create type foo_type as object (
foo number,
member procedure proc(p in number),
...
|
Guys 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 ... |
I'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 ... |
I have problem with my package its looks like:
create or replace
PACKAGE pac AS
TYPE A IS RECORD
(
aa VARCHAR2(255)
);
TYPE B is ARRAY(1) of A;
PROCEDURE proc1( som OUT ...
|
I 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 ... |
I 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 ... |
I have a PL/SQL procedure which sets some variable in user session, like the following:-
Dbms_Session.Set_Context(
NAMESPACE =>'MY_CTX',
ATTRIBUTE => 'FLAG_NAME',
Value => ...
|
Say my UDO (user defined object) is:
create or replace
TYPE UDO_PERSON AS object (NAME VARCHAR2(100), AGE INTEGER);
And I have a PL/SQL function
create or replace
FUNCTION CREATE_A_PERSON(NAME VARCHAR2)
RETURN UDO_PERSON
AS
...
|
|
|
Good 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 ... |
Hi 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. ... |
Hello, 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 ... |
Context: 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 ... |
I 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 ... |
Hi 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 . ... |
----- 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 ... |