Is it possible to working in Java Stored Procedures with OCI driver?

Advertisement

Hello ALL.
Could you help me...
Is it possible to working in Java Stored Procedures with OCI driver?
I want to try to do some workaround...
I need to work with following parametrs from Java Stored Procedures:
DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
String url = null;
url = "jdbc:oracle:oci:@TEST";
conn = DriverManager.getConnection (url,"scott","tiger");
Is it possible?
I tried but I have errors...
Please, help me!
Thanks

Advertisement

You cannot call OCI functions directly from PL/SQL. You could, of course, write an external procedure that made OCI calls, though you could also write an external procedure in Java. I'm guessing the documentation is trying to convey this same information-- you would need an external procedure that used OCI if you wanted to use the old-school interfaces for LONG and LOB data types. If you converted to using LOBs rather than LONGs, you could do everything in PL/SQL.
Justin

November 30, -0001

Is it possible to working in Java Stored Procedures with OCI driver?

Hello ALL. Could you help me... Is it possible to working in Java Stored Procedures with OCI driver? I want to try to do some workaround... I need to work with following parametrs from Java Stored Procedures: DriverManager.registerDriver (new oracle.

Java stored procedure problem(oracle db)

HI, we have a java stored procedure with the following definition, and that works as we want it to: CREATE OR REPLACE FUNCTION processBulletin(in_varchar VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'JavaParser.Bufr_Ingest.processBulletin(java.lan

Java Stored Procedure SAXParser XML Schema Validation

Using Oracle XML Developers Kit 10.2.0.2.0 - Production. Attempting to validate using XML Schema in a Java stored procedure with the code:                if ( schemaDoc == null )                     // Obtain default connection                     Co

Help with use of Java Stored Procedures to invoke Java Code within Applicat

Good afternoon everyone Our development team is looking for some assistance/validation of a design strategy we are deploying for a client. Let me first layout the environment and then the design issue at hand: Business User Workstation component: Ora

Error deploying java stored procedure

Anyway, I've got a really simple java function that takes an XML document in a CLOB as a parameter and simply returns whether or not it's a valid document. Works fine in JDeveloper, but when I try to load it into the database, I get: Errors in cdh_j_

ORA-04030: out of process memory when using Java Stored Procedures

Hello, I have a problem using Java Stored Procedures in Oracle 10g. My Java application performs http posts to a webservice and the response is parsed in order to populate some DB tables. There is a scheduled job which calls the Java Stored Procedure

No method found error when calling java stored procedured

hi: i am rather confused about this. i have written several java stored procedures and all of them work fine. but when i tried another one , the error message 'no method found 'occurs when i call the procedure from sqlplus. it' s a simple procedure .

Deploy package with Java Stored Procedure without JDeveloper

I have a set of Java Stored Procedures deployed as a package on a Oracle 8i server. Everything works fine in my development environment, and now I would like to deploy the same package in the customers runtime environment. Both environments are runni

Problem executing a Java Stored Procedure from Forms6i

I'm executing a Stored Procedure which invokes a Java Stored procedure.Till the invoking it works fine but for accessing a particular class it gives an error: PDE-PLU022 Don't have access to the stored program unit XMLPARSERCOVER in schema CARE where

Invoking a UNIX shell command from Java stored procedure

The program below is suppose do send an email using UNIX mailx program. It works correctly when I compile it in UNIX and invoke it from the command line by sending an email to the given address. I need this program to run as a stored procedure, howev

Forcing a commit in a JAVA stored procedure

Hi, I am using a java stored procedure which updates few tables ;only after it completes the call the commit is happening;But i wanted it to commit the tables as and when the processing happens not at the end of the call to java stored procedure beca

Java Stored Procedure calling HTTP Servlet in Weblogic

I am currently working on an e-commerce application for a brick-n-mortar electronics store. The store currently has an Oracle database that contains all of the products the store sells. The e-commerce site will have a separate Oracle database. Both d

Passing Tables back from Java Stored Procedures

Thomas Kyte has written (in reference to trying to pass an array back from a stored function call): You can do one of two things (and both require the use of objects). You cannot use PLSQL table types as JDBC cannot bind to this type -- we must use O

How to retrive a STANDARD stored procedure with java?

I have searched and searched, I have not found a direct, CLEAR, answer to this. how do you call a standard, (not java) stored procedure from oracle database that requires input variables? I have looked, searched and read and cannot find one simple ex

Java Stored Procedures and Triggers

I want to to use Java stored procedures and triggers within the Oracle 11g XE So please , someone can help me because i tried but it didn't work I don't know where is the problem Thanks !!WRONG FORUM! Welcome to the forum but this forum is for Java J

Jdbc and java stored procedures

Hi all, I am new to Oracle Java Stored Procedures but I am interested in knowing to which extent is object passing supported. Can I send any kind of object to a java stored procedure? And back from the procedure? Anybody knows any good resources onli

Accessing files from Java Stored Procedures

I am trying to access a file from a Java Stored Procedure but get the exception: "no such file or directory". The path and filename as seen by the database JVM is "\\wgcaub01\a1500is\fabi\mmv\mmvtestdata.txt". I have granted permission

Oracle 9.2i AQ: Enqueue from Java Stored Procedure?

Hello all, one implementation needs to poll a database table. With the updated table data we would like to insert a message in a Oracle AQ queue (calling the procedure from a database trigger). There are two options: 1. To write the stored procedure

Creating Threads in Java Stored procedures

Can I create threads inside Java Stored procedures? or is there a restriction? Thanks KalCan I create threads inside Java Stored procedures? or is there a restriction? Thanks Kal Hi Kal, I don't mean to be rude, but have you tried it? Personally, I h

Running a Corba Client as a Java Stored Procedure

Hi, I�m trying to use a Java Stored Procedure running as a Corba Client. I want to use the built in Visibroker ORB on Oracle side and JacORB (or others) on the server side. How can I init the ORB and get a naming service running not in Oracle but on