Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How do I use 'kprb' jdbc driver with java SQLJ stored procedure (oracle)
If your implementing a Java Stored procedure in SQLJ the docs say you must use the KPRB driver in your connect.properties file.
The docs also say that you don't have to connect to the database, since a connection is implied anyway ( your sproc is running in the server already)
So what I don't get is if this:
Since the sproc doesnt connect to the database, you don't use the following line ( like you would for a client side sqlj program)
Oracle.connect(getClass(),"connect.properties");
So how does the sproc know to use the KPRB driver since the driver you want to use is in the connect.properties??
I beleive this is why if I try to invoke my sproc I get the message: ORA-03113: end-of-file on communication channel Received on Sun Aug 13 2000 - 00:00:00 CDT
![]() |
![]() |