| running java-program as UDF [message #109616] |
Sun, 27 February 2005 05:24  |
pplatsch@minet.uni-jena.d
Messages: 2
Registered: February 2005
Location: Germany
|
Junior Member |
|
|
I created a program in Java that inserts some data into an oracle table. I've tested it and it is working fine.
Then I have loaded this program into an Oracle database, registered it and tried to run it as user defined function - it hangs up! Nothing happens no further commands are possible.
In a second connection to Oracle I have reading access to the table used in the UDF, but no writing access.
I have tested the same Java-program as UDF in oracle but without insert-statement. It is working fine.
My question: Is it possible to insert data into a table by a Oracle-UDF? Or do have to use the program as stored procedure in Oracle to be able to insert data into a table?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
